Syntax :
SELECT Column_List FROM table_name1 t1
LEFT OUTER JOIN
table_name2 t2
ON t1.column_name=t2.column_name
Example :
SELECT e.EmpID,e.EmpName,o.OrderNo
FROM EmpDetail e
LEFT OUTER JOIN
OrderDetail o
ON e.EmpID=o.EmpID
SELECT Column_List FROM table_name1 t1
LEFT OUTER JOIN
table_name2 t2
ON t1.column_name=t2.column_name
Example :
SELECT e.EmpID,e.EmpName,o.OrderNo
FROM EmpDetail e
LEFT OUTER JOIN
OrderDetail o
ON e.EmpID=o.EmpID