SQL SERVER – Challenge – Puzzle – Why does RIGHT JOIN Exists | Journey to SQL Authority with Pinal Dave

I had interesting conversation with the attendees of the my SQL Server Performance Tuning course. I was asked if LEFT JOIN can do the same task as RIGHT JOIN by reserving the order of the tables in join, why does RIGHT JOIN exists? The definitions are as following: Left Join - select all the records… Continue Reading...

Source: SQL SERVER – Challenge – Puzzle – Why does RIGHT JOIN Exists | Journey to SQL Authority with Pinal Dave