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