# What is difference between cross join and cross join?

**cross join**matches all rows in one table to all rows in another table. An inner

**join**matches on a field or fields. The

**cross join**will have 100 rows returned and they won't be related, just what is called a Cartesian product. The inner

**join**will match records to each other.

Simply so, what is the difference between cross apply and cross join?

The **CROSS APPLY** operator is semantically similar to INNER **JOIN**. This is similar to the INNER **JOIN** operation performed on the Author and Book tables. **CROSS APPLY** returns only those records from a physical table where there are matching rows **in the** output of the table valued function.

**cross join**is used when

**you**wish to create combination of every row from two tables. All row combinations are included in the result; this is commonly called

**cross**product

**join**. A common

**use**for a

**cross join**is to create obtain all combinations of items, such as colors and sizes.

Likewise, what is a cross join?

In SQL, the **CROSS JOIN** is used to combine each row of the first table with each row of the second table. It is also known as the Cartesian **join** since it returns the Cartesian product of the sets of rows from the joined tables.

The **CROSS JOIN** gets a row from the first table (T1) and then creates a new row for every row in the second table (T2). It then does the same for the next row for in the first table (T1) and so on. In general, if the first table has n rows and the second table has m rows, the **cross join** will result in n x m rows.