In a query, many rows will come from which type of join?

A cross join, also known as a Cartesian product, produces a result set that contains every combination of rows from the participating tables. If Table A has 4 rows and Table B has 3 rows, a cross join will return 4 × 3 = 12 rows. Because it does not use a join condition, it can generate a very large number of rows, especially when the tables are large. This is why cross joins are rarely used in production queries unless you explicitly need every combination of rows.