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

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>...