Question: joins are sql server default?
Answer: The simplest and most common form of a join is the SQL inner join the default join-types of most of the database management systems. It's the default SQL join you get when you use the join keyword by itself. The result of the SQL inner join includes rows from both the tables where the join conditions are met.