This example illustrates a left outer join of the PROCLIB.PAYROLL and PROCLIB.PAYROLL2 tables. proc sql outobs=10; title 'Most Current Jobcode and Salary Information'; select p.IdNumber, p.Jobcode, ...
INNER JOIN publisher as p ON b.publisher_id = p.publisher_id INNER JOIN book_author as ba ON b.book_id = ba.book_id INNER JOIN author as a ON ba.author_id = a.author_id ...