NULL Values in the columns of right table

Q&A
, , ,
1

I connected 2 datasets using left join , but the columns of right table is showing null. I checked joining condition columns’ data types are matching . Can anyone help here?

Thanks

2

Hello @krtse,

Left joins typically show null for the columns in the right table if there’s not a matching row for the column that is being joined on. Say, for example, you have a table that has your customer information in it and a table that has sales in it along with how much each sale was. If you joined on the CustomerID for those two tables (Customer table on left, sales table on right) to show a joined table that has customer_name and amount of each order, for any customer that never had a sale, the amount column in the joined table would be null.

In simpler terms, a left join shows ALL of the records from the left table but only matching records from the right table. If there are no matching records, those columns from the right table will be null.

Did this answer your question? If so, please help the community out by marking this answer as "Solution!