View Single Post
Thyamine

 
Thyamine's Avatar
 
Member Since: Apr 23, 2007
Location: Coatesville, PA
Posts: 377
Thyamine will become famous soon enough
Mac Specs: MBP 15", 2.33 GHz, 2Gb

Thyamine is offline
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