[Solved] What would be output of SQL query if we include two table without any condition

by


If you fix your syntax to

select * from table1, table2;

you will get a join where every condition is true, which is the same as the Cartesian product of the two tables.

table1      table2
------      ------
A           1
B           2
C

Result:

A 1
A 2
B 1
B 2
C 1
C 2

0

solved What would be output of SQL query if we include two table without any condition