hellowhy don't the below queries give the same result ?the second query doesn't include the records where there is no value in XpoMeasures for the spceific combination.SELECT A.MarketSizeDesc, SUM(XpoMeasures.RxUnits) AS Expr1, A.ProdSizeDesc, A.ProductDesc,a.timeperioddescFROM XpoMeasures RIGHT OUTER JOIN(select XpoMarketId,ProductDesc,XpoProdSizeId,ProdSizeDesc, XpoMarketSizeId,MarketSizeDesc,Timeperiodid,timeperioddesc from XpoMarket,XpoProductsize,XpoMarketSize,xpotimeperiod) AONXpoMeasures.XpoMarketId = A.XpoMarketId ANDXpoMeasures.XpoProductSizeId = A.XpoProdSizeId ANDXpoMeasures.XpoMarketSizeId = A.XpoMarketSizeIdGROUP BY A.MarketSizeDesc, A.ProdSizeDesc, A.ProductDesc,a.timeperioddesc
SELECT XpoMarket.ProductDesc, XpoMarketSize.MarketSizeDesc, XpoProductsize.ProdSizeDesc, SUM(XpoMeasures.RxValues) AS Expr1, XpoTimePeriod.TimePeriodDescFROM XpoProductsize LEFT OUTER JOIN XpoMeasures ON XpoProductsize.XpoProdSizeId = XpoMeasures.XpoProductSizeId RIGHT OUTER JOIN XpoMarketSize ON XpoMeasures.XpoMarketSizeId = XpoMarketSize.XpoMarketSizeId RIGHT OUTER JOIN XpoTimePeriod ON XpoMeasures.TimePeriodId = XpoTimePeriod.TimePeriodId RIGHT OUTER JOIN XpoMarket ON XpoMeasures.XpoMarketId = XpoMarket.XpoMarketIdGROUP BY XpoMarket.ProductDesc, XpoMarketSize.MarketSizeDesc, XpoProductsize.ProdSizeDesc, XpoTimePeriod.TimePeriodDesc