Scribd
Upload
32 views2 pages

Left Join Example

The document shows two tables of data, Data A and Data B, that are joined on their ID fields. The resulting joined table combines the data from both tables where the IDs match and fills in NULL values where there is no match.

Uploaded by

Shivansh Sahu
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
32 views2 pages

Left Join Example

The document shows two tables of data, Data A and Data B, that are joined on their ID fields. The resulting joined table combines the data from both tables where the IDs match and fills in NULL values where there is no match.

Uploaded by

Shivansh Sahu
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Data A Data B

aID aName bID bPrice($000)


1 The Coach House 1 354
2 The Gables 2 120
3 Manor Farm 3 276
4 Spring Field 5 441
5 The Bungalow 6 82
8 190

LEFT JOIN

aID aName bID bPrice


1 The Coach House 1 354
2 The Gables 2 120
3 Manor Farm 3 276
4 Spring Field NULL NULL
5 The Bungalow 5 441
aID aName bID bPrice
1 The Coach House 1 354
2 The Gables 2 120
3 Manor Farm 3 276
4 Spring Field NULL NULL
5 The Bungalow 5 441

You might also like