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