Guys do anyone know how to combine three tables in which two tables has common column whereas another table doesn't have com col | SoloLearn: Learn to code for FREE!

0

Guys do anyone know how to combine three tables in which two tables has common column whereas another table doesn't have com col

3/3/2021 9:53:02 AM

LIKITHA S

1 Answer

New Answer

0

You can link the common columns from the first two tables by using a JOIN, and draw from the third table by adding it to the FROM clause. The query might be something like SELECT * FROM table3, table1 INNER JOIN table2 ON table1.col1 = table2.col1 WHERE <add filters here>...