Nikki - try and format the sql a bit better as i find it helps readability
e.g
Code:
SELECT OrdD1.OrderID AS OrderID
, SUM(OrdD1.Quantity) AS "Units Sold"
, SUM(Ord01.UnitPrice * OrdD1.Quantity) AS Revenue
FROM [Order Details] AS OrdD1
WHERE OrdD1.OrderID in (SELECT DISTINCT OrdD2.OrderID
FROM [Order Details] AS OrdD2
WHERE OrdD2.UnitPrice > $100)
GROUP BY OrdD1.OrderID
HAVING SUM(OrdD1.Quantity) > 100
)
also, to improved readability, keep everything lower case. some people keep keys word upper case, so you could try that.
Social Networking Bookmarks