Sobes.tech
Intern — Middle

Calculating the number of rows after table cross-join

livecode

Task condition

Suppose there are two tables: Users (containing 100 records) and Product (also 100 records). It is required to determine how many rows the resulting table will have after executing the following query.

SELECT * FROM users u JOIN
product p ON 1=1