Left Join that always includes null records

You don't need a join here at all:

SELECT  customer_id, NULL AS location_id, addressFROM    customersUNION ALLSELECT  customer_id, location_id, addressFROM    locations

sql oracle join null left-join

You can try a full outer join. For example:

SELECT    CUSTOMERS.CUSTOMER_ID,   LOCATIONS.LOCATION_ID,   NVL(LOCATIONS.ADDRESS,CUSTOMERS.ADDRESS) ADDRESS             FROM  CUSTOMERS     FULL OUTER JOIN  LOCATIONS ON (CUSTOMERS.CUSTOMER_ID=LOCATIONS.CUSTOMER_ID)

sql oracle join null left-join

If you want to join the two tables even when there is a non match, you will need to use IS NULL on your joined columns.

For example.

Table 1:CustomerIDCustomerName

Table 2:CustomerIDCustomerEmail

Select,CustomerID,CustomerName,ISNULL (CustomerEmail, NULL) AS CustomerEmailFROM table1LEFT JOIN table2ON table1.CustomerID = table2.CustomerID

This wil bring back results with NULL

CodeHunter

Left Join that always includes null records

Recent Posts

How can I color dots in a xy scatterplot according to column value?

How to update a claim in ASP.NET Identity?

What does {0} mean when initializing an object?

Accessing members of items in a JSONArray with Java

How to log SQL statements in Spring Boot?

Powershell Get-WebSite name parameter is ignored

How to detect scroll to bottom of html element

Java synchronized method

How to test controllers with CodeIgniter?

Detect Visual Composer

Matplotlib: Specify format of floats for tick labels

Rails join a list of strings with commas and "and" before the last