Home Forums Article Discussions Article Discussions by Author Discuss content posted by bitbucket APPLY - 1 RE: APPLY - 1
Mike Is Here
Hall of Fame
Points: 3348
More actions
September 6, 2012 at 6:14 am
#1534419
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