I have a query that I built via the query builder tool.
It joins 2 tables A and B. Table A is a contact list. B is phone number types.
I joined the 2 tables and select all recored from A.
The query has a condition on B where the phone number type is “CELL”.
Not every record in A is in B.
I expected to return results that had all the records in A and the CELL Phone populated for the contacts that had Cell Phones.
However I get only records where type CELL exists in table B.
I am a little rusty with SQL and would like to do this all throught the QUERY tool.
Suggestions are much appreciated.