:

SQL:

SELECT A.1, A.2, , B.1, B.2, FROM A, B WHERE c;

SELECT A.1, A.2, , B.1, B.2, FROM A CROSS JOIN B WHERE c;