Posted - 04/26/2012 : 15:21:37
Trying to execute this command
select os.OrderedProductSKU, convert(DECIMAL(15,2),SUM(os.OrderedProductPrice)) totalsales
from Orders_ShoppingCart os
join Orders o on o.OrderNumber = os.OrderNumber
where o.OrderDate between '01-Jan-2011' and '01-Jan-2012'
group by os.OrderedProductSKU
order by 2 desc
but I get this error
Msg 208, Level 16, State 1, Line 1
Invalid object name 'Orders_ShoppingCart'.
That is the correct name of the SQL table. Any ideas where its going wrong?