Viewing 5 posts - 1 through 5 (of 5 total)
What syntax error?
I ran the query and it executes !
May 3, 2016 at 11:15 pm
SELECT SalesOrderNumber, sum([Nett])
FROM (([FactSales]
inner join [Date]
on [FactSales].DateKey = [Date].DateKey)
inner join [Product] on [Sales].ProductKey = [Product].ProductKey
inner join [ProductCategory] on [Product].ProductCategoryKey = [ProductCategory].ProductCategoryKey)
inner join [Store] on [Sales].StoreKey = [Store].StoreKey)
where FullDate = '2016-04-27'
and...
May 3, 2016 at 10:50 pm
Already posted!
May 3, 2016 at 7:47 pm
Its just giving me total of only beverages in it.
Referring to the example in my first post, its giving beverages (5$) + beverages (10$) = 15$.
I am expecting 27$.
Thanks
May 3, 2016 at 7:12 pm
SELECT Product Class, sum([Nett])
FROM (([FactSales]
inner join [Date]
on [FactSales].DateKey = [Date].DateKey)
inner join [Product] on [Sales].ProductKey = [Product].ProductKey
inner join [ProductCategory] on [Product].ProductCategoryKey = [ProductCategory].ProductCategoryKey)
inner join [Store] on [Sales].StoreKey = [Store].StoreKey)
where FullDate =...
May 3, 2016 at 6:02 pm
Viewing 5 posts - 1 through 5 (of 5 total)