You have to tables A and B as following:

Table A:

A1 | A2
--------
a11 | a12
a21 | a22


Table B:

B1 | B2
--------
b11 | b12
b21 | b22

I run following statement:

Select * From A, B

What would be the result?

Answer: CROSS-JOIN

a11 | a12 | b11 | b12
a11 | a12 | b21 | b22
a21 | a22 | b11 | b12
a21 | a22 | b21 | b22









Answers and Comments