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