SQLTeam.com | Weblogs | Forums

Sql query


#1

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


#2

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


#3

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?


#4

Apologies. incorrect post