about left join in this cousre
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
Super learner
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.
Tsvetelin Tsonkov
Instructor
Hi Mohamed and Abdur!
Thanks for reaching out.
@: Abdur
Thanks for sharing this piece of information with the Community!
@: Mohamed
As Abdur said it depends on the columns you would like to display in your result set.
Hope this helps.
Best,
Tsvetelin