[Solved] Joining two tables without filtering the data on the basis of joining condition

by


A left outer join assuming the first table is used first. A SQL syntax for the above would be:

SELECT * 
FROM Table1  
LEFT JOIN Table2 On Table1.ID1=Table2.ID2

solved Joining two tables without filtering the data on the basis of joining condition