How to select a single record in a left join

From Logic Wiki
Jump to: navigation, search

OUTER APPLY

SELECT M.ModelID,
      M.Model,
      C.Content
FROM   Models M
      OUTER APPLY (SELECT TOP 1 *
                   FROM   Models_Content C
                   WHERE  M.ModelID = C.ModelID
                   ORDER  BY C.ContentID ASC) C
WHERE  M.ModelID = 5