Last answered:

28 Nov 2022

Posted on:

26 Nov 2022

0

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

0

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.

Instructor
Posted on:

28 Nov 2022

0

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

Submit an answer