I'm trying to create a temporary view based on a row existing in one table, and not existing in another. Tables are as follows
Create Temporary View SLabelOrder as SELECT T1.PARTNMBR, T1.SSORDNMB, + T2.CUSTCODE,T3.ShipName,T3.ShipAdd1,T1.CUSTCODE, T4SSOrdNmb FROM ShipLabelHist + T1,ORDENTRY T2,CustCode T3,PackTble T4 WHERE T1.SSORDNMB = T2.SSOrdNmb + AND T1.SSORDNMB <> T4.SSOrdNmb AND + T2.CUSTCODE = T3.CustCode + ORDER BY T1.CUSTCODE ASC,T1.SSOrdNmb ASC This query doesn't work properly. What I WANT to do is to create the view where the SSOrdNmb is not present in the PackTble, to choose which rows are left to add to the packtble. It definately doesn't HAVE to be a view, as I can create a temporary table subtracting the 2, or whatever. I'm open to ideas. TIA Damon Damon D. Kaufman President Stalder Spring Works, Inc ISO-9002 / QS-9000 Certified 2345 S. Yellow Springs St. Springfield, Ohio 45506 Voice 937-322-6120 Fax 937-322-2126 email: [EMAIL PROTECTED]
