harshadborde
Registered User.
- Local time
- Tomorrow, 01:06
- Joined
- Apr 10, 2017
- Messages
- 17
Cartesian Join: Result changing when tables added to FROM
Hello Friends,
Below are 2 quries, both are same with only difference is added table in FROM
SELECT [TableA].Storename, Sum([TableA].[Sum Of Total]) AS [SumOfSum Of Total], Sum([TableA].[Sum Of Q1 Revenue]) AS [SumOfSum Of Q1 Revenue]
FROM [TableA]
GROUP BY [T&M Table].Storename;
SELECT [TableA].Storename, Sum([TableA].[Sum Of Total]) AS [SumOfSum Of Total], Sum([TableA].[Sum Of Q1 Revenue]) AS [SumOfSum Of Q1 Revenue]
FROM [TableA],[TableB]
GROUP BY [T&M Table].Storename;
Both results are coming different even though I am fetching same field from same table, even though there is same table in Select. Kindly help.
Hello Friends,
Below are 2 quries, both are same with only difference is added table in FROM
SELECT [TableA].Storename, Sum([TableA].[Sum Of Total]) AS [SumOfSum Of Total], Sum([TableA].[Sum Of Q1 Revenue]) AS [SumOfSum Of Q1 Revenue]
FROM [TableA]
GROUP BY [T&M Table].Storename;
SELECT [TableA].Storename, Sum([TableA].[Sum Of Total]) AS [SumOfSum Of Total], Sum([TableA].[Sum Of Q1 Revenue]) AS [SumOfSum Of Q1 Revenue]
FROM [TableA],[TableB]
GROUP BY [T&M Table].Storename;
Both results are coming different even though I am fetching same field from same table, even though there is same table in Select. Kindly help.
Last edited: