KnowledgeBoat Logo

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

2 Likes


Related Questions