SQL Server 2005 SUM

Question

Hey all, this is my query string here:

 SELECT SUM(Total) as Total, AdministratorCode, SUM(WOD.Quantity) as thePass 
 FROM   tblWO as WO, 
        tblWOD as WOD
 WHERE WOD.OrderID = WO.ID 
 AND WO.OrderDate BETWEEN '2010-01-01' AND '2010-08-31' 
 AND Approved = '1' 
 ORDER BY WO.AdministratorCode

But i keep getting the error:

The multi-part identifier "tblWOD.Quantity" could not be bound.

Any help would be great!

Thanks,

David

SOLVED!!!

Answer 1

You need to use SUM(WOD.Quantiy) (or maybe Quantity unless the column name is missing a t)

You have aliased the table here tblWOD as WOD so you have no table with the exposed correlation name tblWOD

Answer 2

In your Select clause, use just: SUM(Quantiy) rather than SUM(tblWOD.Quantiy). SUM(WOD.Quantiy) should also work

Answer 3

I believe you might need something like this

SELECT
    SUM(Total) as Total,
    WO.AdministratorCode,
    SUM(WOD.Quantity) as thePass
FROM tblWO as WO, tblWOD as WOD
WHERE
    WOD.OrderID = WO.ID
    AND WO.OrderDate BETWEEN '2010-01-01' AND '2010-08-31'
    AND [TableReference].Approved = '1'
Group By WO.AdministratorCode
ORDER BY WO.AdministratorCode