not including null values in sql join
- by Ashanti
Hi,
I have two tables CustomerAddress(CustomerId, City, Country) and CustomerTransactions(TransactionId, CustomerId, CustomerContact). Here are the values in the tables:
For CustomerAddress:
1001, El Paso, USA
1002, Paris, France
1003, Essen, Germany
For CustomerTransactions:
98, 1001, Phillip
99, 1001, NULL
100, 1001, NULL
101, 1003,…