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