Damon,
Try:
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
You don't need to name custcode twice, since it is equal in both
places, you need only one copy of it in your view.
Bill
On Sat, 8 Feb 2003 11:12:50 EST, [EMAIL PROTECTED] wrote:
>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
>
