In a message dated 2/8/2003 11:27:20 AM Eastern Standard Time, [EMAIL PROTECTED] writes:
> Create Temporary View SLabelOrder + > (PartNmbr, SSOrdNmb, CustCode, ShipName, ShipAdd1) + > as SELECT + > T1.PARTNMBR, T1.SSORDNMB, + > T2.CUSTCODE,T3.ShipName,T3.ShipAdd1 + > FROM ShipLabelHist T1,ORDENTRY T2, CustCode T3 + > WHERE (T1.SSORDNMB = T2.SSOrdNmb) + > AND (T2.CUSTCODE = T3.CustCode) + > AND (T1.SSORDNMB NOT IN + > ( SELECT SSOrdNmb FROM PackTble T4)) + > ORDER BY T1.CUSTCODE ASC,T1.SSOrdNmb ASC > Bill, Worked like a charm !! I've been flogging that code for about 6 hours now. Thank you very much for your time and effort. That's another buck or 2 for Project Bundle up, and I'll quit picking on the G*** subject <g> Damon
