Since left join extract all records of the table on the left, why not extract a column from_date , to_date ?

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. @: 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