SUBQUERY PROBLEM AGAIN

[Odimar Tomazeli]

Hi guys

I tried again the subquery but doesn't work

SELECT n.Cust_no, n.Customer, n.RevenueType, n.GLAccount, n.GLLogicalAccount, n.GLGrouping, n.ProfitCenter, n.ServiceProvider, n.TotalAmountCAD, n.Amount
FROM nm1_eod n
WHERE n.PostingDate between '2005-09-01 00:00:00' and '2005-09-30 00:00:00'
AND n.Cust_no in ( SELECT DISTINCT cust_no FROM nm1_eod
WHERE PostingDate between '2005-09-01 00:00:00' and '2005-09-30 00:00:00'
AND LegalEntity IN('XNX') AND GLLogicalAccount IN ('ADJ','REVENUE') AND Submarket IN('NEX','CSG')
AND GLAccount IN ('2201000','2202000','2203000','2204000','2192100','2192105','2192110','2192125'))
Order by n.Cust_no


and after I tried to change to

SELECT n.Cust_no, n.Customer, n.RevenueType, n.GLAccount, n.GLLogicalAccount, n.GLGrouping, n.ProfitCenter, n.ServiceProvider, n.TotalAmountCAD, n.Amount
FROM nm1_eod n LEFT JOIN nm1_eod ne
ON (n.Cust_no = ne.Cust_no AND ne.PostingDate between '2005-09-01 00:00:00' and '2005-09-30 00:00:00'
AND ne.LegalEntity IN('XNX') AND ne.GLLogicalAccount IN('ADJ','REVENUE') AND ne.Submarket IN('NEX','CSG')
AND ne.GLAccount IN ('2201000','2202000','2203000','2204000','2192100','2192105','2192110','2192125'))
WHERE n.PostingDate between '2005-09-01 00:00:00' and '2005-09-30 00:00:00'
AND ne.Cust_no IS NULL
Order by n.Cust_no

What am I doing wrong?



Edited 1 time(s). Last edit at 02/17/2006 01:38PM by Odimar Tomazeli.