what is wrong with the following query...
SELECT DISTINCT ordernumber, COUNT(ordernumber) AS Num_of_Brns 
FROM orderheader 
WHERE (vendorID, depotnumber) IN 
                (SELECT vendor_id, depot_id
		FROM vendordepot 
		WHERE vendorDepot_id IN (32092,32093)) 
GROUP BY ordernumber 
HAVING count(ordernumber) > 1 
ORDER BY ordernumber
I get two errors.
*Server: Msg 170, Level 15, State 1, Line 3
Line 3: Incorrect syntax near ','.
*Server: Msg 156, Level 15, State 1, Line 7
Incorrect syntax near the keyword 'GROUP'.

I'm using sql server 2000