I've got a complex query... I was wondering if someone could give me some
advice..
Is there any way that I can base the WHERE clause of a query on the contents
of another table?? for instance...
SELECT name FROM mytable WHERE(ID=myothertable.idlistcolumn);
where myothertable is a HEAP
February 2001 2:45 p.m.
To: [EMAIL PROTECTED]
Subject: Complex Query Problems
I've got a complex query... I was wondering if someone could give me some
advice..
Is there any way that I can base the WHERE clause of a query on the contents
of another table?? for instance...
SELECT name FROM mytable