clarification of LEFT JOIN
Hi there!
After watching the lessons can i say the left join is a way to display the whole left table + add extra columns from the right table as descriptive columns" as needed" under specifying the matching condition.....
After watching the lessons can i say the left join is a way to display the whole left table + add extra columns from the right table as descriptive columns" as needed" under specifying the matching condition.....
Is that right?
1 answers ( 0 marked as helpful)
Hi Abdulrahman!
Thanks for reaching out!
Yes, you’re mostly correct. A LEFT JOIN includes all the rows from the left table and adds columns from the right table where there’s a match based on the specified condition. If there’s no match, the extra columns from the right table will have NULL values.So, you can think of it as displaying the whole left table and adding extra descriptive columns from the right table wherever there’s a match.
Best,
