SQL Database Concepts Question:
Download Questions PDF

Explain difference between cross join and Full outer join?

Basic SQL Server Interview Question
Basic SQL Server Interview Question

Answer:

Cross Join :
No join conditions are specified.
Results in pairs of rows.
Results in Cartesian product of two tables.

Full Outer Join:
A combination of both left and right outer joins.
Results in every row from both of the tables , at least once.
Assigns NULL for unmatched fields.

Download Basic SQL Server Interview Questions And Answers PDF

Previous QuestionNext Question
Do you know how to send email from database?Do you know what is a Trace frag? Where do we use it?