Join - Oracle FAQ

A left outer join retrieves all the rows of the left table plus the information of the right table with a common key: SQL> SELECT * 2 FROM a LEFT OUTER JOIN b ON idA = idB; IDA VALA IDB VALB 1 in A and ...

www.orafaq.com