Question

What are the Join Types in TSQL?

Answer 1

Join Types in TSQL are,

• Inner join
• Outer join
• Left outer join
• Right outer join
• Left outer join with Exclusions
• Right outer join with Exclusions
• Full outer join
• Full outer joins with Exclusions
• Cross join

Answer 2

Join Types in TSQL are,

1. Inner join
2. Outer join
3. Left outer join
4. Right outer join
5. Left outer join with Exclusions
6. Right outer join with Exclusions
7. Full outer join
8. Full outer joins with Exclusions
9. Cross join