> Home > Scripts > SQL

 

Example of an outer join:

 

The purpose of an outer join is to include all information from the first table and also include any additional information from the second table if data exists.

 

 

SELECT CA.NAME

FROM CUSTOMER_ADDRESS CA, CUSTOMER_SERVICE_LOCATION CSL

WHERE CA.NAME = CSL.NAME

AND CA.ADDRESS_ID = CSL.ADDRESS_ID (+)

;