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
1 Like
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 ?