>>TEXT TO cSqlCommand NOSHOW >>select C1.*, C2.LASTNAME, C2.FIRSTNAME, C2.TELEPHONE1 >> from COMPANY C1 >> LEFT JOIN (SELECT LASTNAME, FIRSTNAME, TELEPHONE1, COMP_PK FROM PEOPLE p3 >> WHERE ORDERNO = (SELECT MIN(ORDERNO) FROM PEOPLE p4 where p3.comp_pk =p4.comp_pk )) C2 ON C1.COMP_PK = C2.COMP_PK >>ENDTEXT >>>>