Is it possible to run a query on two related tables to return records where the value of a field in the Main table is not null and a value of a different field in the Related table is not null. So by example if I had Table3 and Table4 related by NameID. My desire is to return all records that have a value in the LastName field in Table3 and a value in the City field in Table4. Is this possible?
I have a Left Join query that is returning more records than I want to see. In the attached jpeg (JoinQry.jpg) I am desiring only the records that have a red arrow. Any help is appreciated. Thanks.
Code:SELECT Table3.NameID, Table3.FirstName, Table3.LastName, Table4.City FROM Table3 LEFT JOIN Table4 ON Table3.NameID=Table4.NameID;