select A.ContractID, ;
   B.LastName LN1, C.LastName LN2, D.LastName LN3 ;
   E.LastName LN4, F.LastName LN5, G.LastName LN6 ;
   from Contracts A ;
      left join Customer B on A.CustID1 = B.CustID ;
      left join Customer C on A.CustID2 = C.CustID ;
      left join Customer D on A.CustID3 = D.CustID ;
      left join Customer E on A.CustID4 = E.CustID ;
      left join Customer F on A.CustID5 = F.CustID ;
      left join Customer G on A.CustID6 = G.CustID ;
 order by 1

Mark McCasland
Midlothian, TX  USA