====== Oracle - SQL - Join - Left Join ====== SELECT column_name(s) FROM table_name1 LEFT JOIN table_name2 ON table_name1.column_name=table_name2.column_name