Informatics Practices
Answer
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;
Related Questions
How is a left join different from a natural join ?
How is a cross join different from natural join ?
What is the difference between ON and USING join-clauses ?
A table STUDENT has 4 rows and 2 columns and another table TEACHER has 3 rows and 4 columns. How many rows and columns will be there if we obtain the Cartesian product of these two tables ?