Hi everyone, I am an absolute beginner to SQL and for a project I have to basically access a couple of tables and aggregate the data. I have included the code below and was wondering if you guys can tell me whats wrong with it. I think the SQL Statement (although poorly written) is pretty much self explanatory but let me know if needed an explaination.Thank you in advance for any helpJasonSELECT (dbo.Product.SKU & dbo.ProductVariant.SKUSuffix) as SKU, dbo.ProductVariant.Inventory AS Avaliable, (SELECT sum(dbo.Orders_ShoppingCart.Quantity FROM dbo.Orders_ShoppingCart INNER JOIN dbo.Orders ON dbo.Orders_ShoppingCart.OrderNumber = dbo.Orders.OrderNumber WHERE ((dbo.Orders.ShippingTrackingNumber IS NULL) OR (dbo.Orders.ShippingTrackingNumber = N'')) AND ((dbo.Orders.TransactionState = N'Captured') OR (dbo.Orders.TransactionState = N'Pending')) AND (dbo.Orders_ShoppingCart.VariantID = dbo.ProductVariant.VariantID) Group BY(dbo.Orders_ShoppingCart.VariantID) Order By dbo.Orders_ShoppingCart.VariantID) as PendingFROM dbo.ProductVariant INNER JOIN dbo.Product ON dbo.ProductVariant.ProductID = dbo.Product.ProductID
Need Help with a bit of a query
Posted - 2010-10-15 : 12:19:03
