Last edited by kuau; 02-09-2010 at 10:45 PM. Reason: must have been a dumb question
In MySQL, CROSS JOIN is a syntactic equivalent to INNER JOIN (they can replace each other). In standard SQL, they are not equivalent. INNER JOIN is used with an ON clause, CROSS JOIN is used otherwise.
For more information visit http://dev.mysql.com/doc/refman/5.0/en/join.html