left join

1SELECT table1.column1, table2.column2...
2FROM table1
3LEFT JOIN table2
4ON table1.common_field = table2.common_field;
5

1SELECT table1.column1, table2.column2...
2FROM table1
3RIGHT JOIN table2
4ON table1.common_field = table2.common_field;

1123SELECT columns  FROM table_A  LEFT JOIN table_B ON join_conditionsXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

1Matching part from both table and unmatching part from left table.

1SQL> SELECT  ID, NAME, AMOUNT, DATE
2   FROM CUSTOMERS
3   LEFT JOIN ORDERS
4   ON CUSTOMERS.ID = ORDERS.CUSTOMER_ID;

1SELECT *
2FROM Table_A A
3LEFT JOIN Table_B B
4ON A.col = B.col;
5