MSSQL OUTER APPLY

모바일 & 앱 2021. 7. 23. 10:06

반응형

SELECT
*
FROM
TABLE1 AS TBL1
OUTER APPLY (
  SELECT
     *
  FROM
     JOINTABLE AS TBL2
  WHERE
      TBL1.KEY = TBL2.KEY ) AS RESULT

 

자꾸 까먹어서 써놓음

반응형
Posted by Hippalus

댓글을 달아 주세요