Question: what is difference between logical join and physical join?
Answer: 1. Logical Joins: These joins are simple joins that we apply in our SQL queries, like INNER JOIN, RIGHT/LEFT OUTER JOIN, CROSS JOIN, OUTER APPLY, etc. 2. Physical Joins: These are the joins that users don't use/write in their SQL queries.