The SQL Procedure

Example 9: Joining Three Tables

Procedure features:

FROM clause

joined-table component

WHERE clause

Tables:

PROCLIB.STAFF2, PROCLIB.SCHEDULE2, PROCLIB.SUPERV2

This example joins three tables and produces a report that contains columns from each table.

PROCLIB.STAFF2

PROCLIB.SCHEDULE2

PROCLIB.SUPERV2

libname proclib 'SAS-data-library';

options nodate pageno=1 linesize=80 pagesize=60;

   proc sql;
title 'All Flights for Each Supervisor';
   select s.IdNum, Lname, City 'Hometown', Jobcat,
          Flight, Date

      from proclib.schedule2 s, proclib.staff2 t, proclib.superv2 v

      where s.idnum=t.idnum and t.idnum=v.supid;