SQL Server: What is the difference between CROSS JOIN and FULL OUTER JOIN?

by

A cross join produces a cartesian product between the two tables, returning all possible combinations of all rows. It has no on clause because you’re just joining everything to everything.

A full outer join is a combination of a left outer and right outer join. It returns all rows in both tables that match the query’s where clause, and in cases where the on condition can’t be satisfied for those rows it puts null values in for the unpopulated fields.

This wikipedia article explains the various types of joins with examples of output given a sample set of tables.

More Related Contents:

  1. Subquery in select not working in SQL Server
  2. Storing images in SQL Server?
  3. How to create jobs in SQL Server Express edition
  4. Limitations of SQL Server Express
  5. SQL time difference between two dates result in hh:mm:ss
  6. What is the best way to truncate a date in SQL Server?
  7. Dynamic SQL (passing table name as parameter)
  8. What is a Trusted Connection?
  9. Understanding SQL Server LOCKS on SELECT queries
  10. “order by newid()” – how does it work?
  11. How to determine total number of open/active connections in ms sql server 2005
  12. Handling date in SQL Server
  13. Tablix: Repeat header rows on each page not working – Report Builder 3.0
  14. ORDER BY DATE showing NULLS first then most recent dates
  15. How to split a string after specific character in SQL Server and update this value to specific column
  16. Avoid Naming User Stored Procedures SP% or SP_%
  17. SQL Server Configuration Manager cannot be found
  18. SQL Server Group by Count of DateTime Per Hour?
  19. Temporarily disable all foreign key constraints
  20. SQL Server Dependencies
  21. SQL Server Passthrough query as basis for a DAO recordset in Access
  22. T-SQL query to show table definition?
  23. Why do I get the error “Xml data type is not supported in distributed queries” when querying a linked server for non-xml data?
  24. Cannot find either column “dbo” or the user-defined function or aggregate “dbo.Splitfn”, or the name is ambiguous
  25. Date range overlapping check constraint
  26. SQL Server 2008 can’t login with newly created user
  27. Taking the second last row with only one select in SQL Server?
  28. What is the difference between Cartesian product and cross join?
  29. How to Bulk Insert from XLSX file extension?
  30. Count number of records returned by group by

Leave a Comment