Last answered:

28 Nov 2022

Posted on:

26 Nov 2022


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)
Super learner
This user is a Super Learner. To become a Super Learner, you need to reach Level 8.
Posted on:

27 Nov 2022


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.

Posted on:

28 Nov 2022


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.

Submit an answer