• I guess I don't understand the question. How is using cross-apply with a where join any different then an inner join with the ON (or where) join

    SELECT

    tblA.S

    , tblA.R

    , tblB.S

    FROM

    #A tblA

    INNER JOIN

    #B tblB

    ON tblA.R = tblB.R