Informatics Practices
Can you join two tables without using the keyword JOIN ?
SQL Joins & Grouping
2 Likes
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;
Answered By
3 Likes
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 ?