bjbrown
asked on
SQL Query to pull two fields from two different tables
I'm trying to do the following using a select to find all addrnames that do not have a zipcode. Addrname and zipcode live in two different tables.
----pseudo code
SELECT DISTINCT Addrname
from tableA
where tableB.zipcode is NULL
----pseudo code
SELECT DISTINCT Addrname
from tableA
where tableB.zipcode is NULL
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.