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)