SELECT dbo_tblAddLine3c.Model_code, Thread_Colors.Thread_Id, dbo_tblAddLine3c.Key_pr
FROM ((dbo_tblAddLine3c LEFT JOIN dbo_tblGoodsCloth ON dbo_tblAddLine3c.GoodsID = dbo_tblGoodsCloth.gGoodsID) 
     LEFT JOIN Material_SPC ON (dbo_tblGoodsCloth.Color = Material_SPC.Color)
  AND (dbo_tblGoodsCloth.Pattern = Material_SPC.Patern)
  AND (dbo_tblGoodsCloth.Sitting = Material_SPC.Sitting)) LEFT JOIN Thread_Colors ON Material_SPC.Id = Thread_Colors.SPC_Id
WHERE (((dbo_tblAddLine3c.Delivery)= 4993 ));

SELECT CDLDS1.Key_pr, CDLDS1.Model_code, Min(IIf(IsNull(ChargeOfThread.Variant), 1 ,(ChargeOfThread.Variant))) AS Variant
FROM CDLDS1 LEFT JOIN ChargeOfThread ON (CDLDS1.Model_code = ChargeOfThread.Model) 
  AND (CDLDS1.Thread_Id = ChargeOfThread.Thread_ID)
GROUP BY CDLDS1.Key_pr, CDLDS1.Model_code;