JOINS and SET Operations — Question 9

Yes, we can join two tables without using the JOIN keyword. This can be done using the comma (,) operator in the FROM clause to combine tables and using the WHERE clause to specify the join condition. The syntax to perform a JOIN between tableA and tableB on the common column "column1" is as follows:

SELECT * FROM tableA, tableB WHERE tableA.column1 = tableB.column1;