about left join in this cousre
in SQL / LEFT JOIN - Part II
Since left join extract all records of the table on the left, why not extract a column from_date , to_date ?
2 answers ( 0 marked as helpful)
Md Abdur Rakib
This user is a Super Learner. To become a Super Learner, you need to reach Level 8.
You can choose the columns you would like to retrieve and leave the others from the tables you are joining. It all depends on what you are trying to see in your result set.
Hi Mohamed and Abdur!
Thanks for reaching out.
Thanks for sharing this piece of information with the Community!
As Abdur said it depends on the columns you would like to display in your result set.
Hope this helps.
Submit an answer
Is this hard core rule that left and right join are perfectly one to many relationship???