SQL - unión cruzada en sql

IF OBJECT_ID('tempdb..#tmpRecData') IS NOT NULL

     DROP TABLE #tmpRecData

--STEP 1

SELECT DISTINCT

    pr.ChainID, pr.StoreID, pr.SupplierID, pr.ProductID,

    MAX(CAST(pr.ActiveLastDate AS date)) AS 'Active Date'

    --ChainID, SupplierID, StoreID, InvoiceDate, InvoiceNumber, SupplierInvoiceDate, SupplierInvoiceNumber

INTO

    #tmpRecData

FROM

    dbo.[ProductPrices_Retailer] AS pr

LEFT JOIN

    ProductIdentifiers iden ON pr.ProductID = iden.ProductID

                            AND iden.ProductIdentifierTypeID = 2

WHERE

    pr.ChainID = '119121'

    AND pr.ActiveLastDate > '12/01/2016'

GROUP BY

    pr.ProductID, pr.ProductName, iden.IdentifierValue,

    pr.ChainID, pr.StoreID, pr.SupplierID

--STEP 2

SELECT

    rec.ChainID, rec.StoreID, rec.SupplierInvoiceNumber,

    rec.TransactionTypeID, rec.SupplierID, rec.SaleDateTime,

    rec.ProductID, rec.UPC, rec.ProductDescriptionReported,

    rec.RawProductIdentifier

FROM

    #tmpRecData t

INNER JOIN

    dbo.StoreTransactions AS rec WITH (NOLOCK) ON rec.ChainID = T.ChainID

WHERE

    rec.ChainID = '119121'

DROP TABLE #tmpRecData