Keyword Join or Inner Join – SQL in Sixty Seconds #099


 

Have you ever wondered what is the difference between keyword Join or Inner Join? Are they same or different? If different, how are they different? We will discuss that in today’s SQL in Sixty Seconds.

During the recent Comprehensive Database Performance Health Check, I was asked by my client this very simple but interesting question – what is the difference between Join or Inner Join. Before I answered him, I asked him back about his current understanding. The client DBA said he believes when he writes INNER JOIN, SQL Server knows to do INNER JOIN but if he does not write