Then, you will create an outer join that combines this data with data from another table to compute the gross monthly pay for employees who have taken leave. Creating a Query View You can create an ...

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, ...

even though a Union Join doesn't appear to be supported in 8i. I might be able to manipulate a Full Outer Join to get the results I need, but that's not supported either.<P>I need to get ALL of ...