SQLTeam.com | Weblogs | Forums

Sql query


I have summarized everything for my request as follows: thank you
incorrect post.


Looks like homework or a test. You need to take a stab at it and post your attempt.


This definitely looks like homework. I can walk you thru the process of creating a query, but I can't just write it for you.

Have you used CROSS APPLY or OUTER APPLY in class? Have you used LEFT OUTER JOIN or just INNER JOIN?


Apologies. incorrect post