Select the columns. The SELECT clause selects all columns that are returned by the in-line view (which will have the alias Three assigned to it), plus one column from the third table (which will have the alias V assigned to it).


proc sql;
   title 'All Flights for Each Supervisor';
   select three.*, v.jobcat