>SELECT Project, a.eocname Owner, ;
>  b.oecname Engineer, c.oecname Contractor;
>  FROM Table2;
>  LEFT JOIN Table1 a;
>    ON Table2.Owner = a.oecid;
>  LEFT JOIN Table1 b;
>    ON Table2.Engineer = b.oecid;
>  LEFT JOIN Table1 c;
>    ON Table2.Contractor = b.oecid;
>  INTO CURSOR crsResults NOFILTER
>