cross join

Share This

“In a query, a cross join matches every row in the first table with every row in the second table. If the first table contains m rows and the second contains n rows, the resulting query will contain m * n rows. Across join is created in SQL when no JOIN condition is listed. Cross joins should be avoided except for instances with a small number of rows.”

« Back to Glossary Index Download Tooltip Pro
By |February 1st, 2019|Comments Off on cross join