;WITH t AS
(
SELECT
          a.*,
        d.DRN,
        d.Bid dBid,
        d.Product dProduct,
        d.Offer dOffer,
        ROW_NUMBER() OVER (ORDER BY a.Product) RN
    FROM CanadianCrudes a
    OUTER APPLY
    (
    SELECT *,
            ROW_NUMBER() OVER (ORDER BY d.Product) DRN
        FROM CanadianCrudes d
        WHERE d.Product LIKE (a.Product + '/%')
            OR d.Product LIKE ('%/' + a.Product)
   )  d
   WHERE d.Product IS NOT NULL
)