|
|
Member Since: Apr 23, 2007
Location: Coatesville, PA
Posts: 377
Mac Specs: MBP 15", 2.33 GHz, 2Gb
|
02-06-2009, 01:38 PM
You could also do something like:
Code:
select * from tableA where ID in (select ID from tableB where status = 'Y')
or similiarly
Code:
select * from tableA where ID in (select ID from tableB where status in ('Y', 'N', 'M')
where you adjust the criteria for what ID's to return.
|
|
|
QUOTE
Thanks
|