select from one, depending on the other
Posted: Fri Feb 10, 2006 12:01 pm
I would like to select information from Table1 where Table2.field1 is not empty.
There is a link between them Table1.filed1 is the same as Table2.field2...
This is what I have in head although it doesn't work, is it possible to do this without doing 2 queries?
Is this possible?
There is a link between them Table1.filed1 is the same as Table2.field2...
This is what I have in head although it doesn't work, is it possible to do this without doing 2 queries?
Code: Select all
SELECT *
FROM Table1
WHERE
Table1.Field1=theID AND (Table2.Field1<>"" AND Table2.Field2=theID)