Один запрос на две таблицы

select RegionId, [64] as 'P_Pr_64', [65] as 'P_Pr_65', [66] as 'P_Pr_66', [78] as 'P_Pr_78', [79] as 'P_Pr_79', [85] as 'P_Pr_85', [86] as 'P_Pr_86', [98] as 'P_Pr_98', [99] as 'P_Pr_99', [112] as 'P_Pr_112', [197] as 'P_Pr_197'
, [64] as 'P_Qty_64', [65] as 'P_Qty_65', [66] as 'P_Qty_66', [78] as 'P_Qty_78', [79] as 'P_Qty_79', [85] as 'P_Qty_85', [86] as 'P_Qty_86', [98] as 'P_Qty_98', [99] as 'P_Qty_99', [112] as 'P_Qty_112', [197] as 'P_Qty_197'
from
    (
    select alls.RegionId as RegionId
    , alls.ProductId as ProductId
    , avgs.UnitPrice as AvgPrice
    , avgs.CountInOrder as AvgNum
        from 
    (select r.RegionId
    , p.ProductId
    from Studing.Region r, Studing.Products p) as alls 
    left join
        (Select r.RegionId
        , p.ProductId
        , op.UnitPrice
        , op.CountInOrder
        from Studing.Region r 
        inner join Studing.Customers c on r.RegionId=c.RegionId
            inner join Studing.Orders o on c.CustomerId=o.CustomerId 
                inner join Studing.OrdersProducts op on op.OrderId=o.OrderId
                    inner join Studing.Products p on p.ProductId=op.ProductId
        ) as avgs on alls.RegionId=avgs.RegionId and alls.ProductId=avgs.ProductId
    ) as SourceTable
pivot
( AVG(SourceTable.AvgNum) for SourceTable.ProductId in ( [64], [65], [66], [78], [79], [85], [86], [98], [99], [112], [197]) ) as PivotTableOne
full join
 pivot
( AVG(SourceTable.AvgPrice) for SourceTable.ProductId in ( [64], [65], [66], [78], [79], [85], [86], [98], [99], [112], [197]) ) as PivotTableTwo on PivotTableOne.RegionId=PivotTableTwo.RegionId)

select p1.*,p2.*
from 
  source1 s1 pivot(...) p1
full join
  source2 s2 pivot(...) p2 on p2...=p1...