摘要:
收藏SQL查询cross join 的用法(笛卡尔积)select a.Dealer, a.ProductCategoryI, a.CalendarYear, ('Q' + cast(a.CalendarQuarter as nvarchar(4))) as CalendarQuarter, sum(b.AmountUSD)as AmountUSD from(select e.Dealer, b.ProductCategoryI, b.CalendarYear, d.CalendarQuarterfrom DimDate a full join (select ... 阅读全文