join

:

sql

Suppose table A has 5 records of data and table B has 6 records. You perform a cross join on these two tables. How many records will the result set consist of?

sql

Suppose table A consists of 7 records and table B consists of 3 records. You perform a cross join on these two tables. How many records will the result set consist of?

sql

JOIN, CROSS JOIN, and INNER JOIN in MySQL

sql

CARTESIAN JOIN or CROSS JOIN

sql

INNER JOIN example

sql

What is the name of an operation that returns all the possible combinations of rows from all tables listed in the query?

sql

A Cross Join is equivalent to:

sql

Given tableA (containing 10 records) and tableB (containing 5 records), what is the smallest possible number of records that may be returned by a query that performs INNER JOIN of two tables?

sql

SQL - INNER JOINS

sql

Example - INNER JOINS