Search Blog

Search duranek.blogspot.com

Wednesday, January 18, 2012

Cross Join

What Mean SQL Cross Join ?

This is cartesian multiplication. Multiplying first
table with the second.

SELECT * FROM [TABLE 1] CROSS JOIN [TABLE 2]

OR

SELECT * FROM [TABLE 1], [TABLE 2]


No comments: