Got it Luis, I appreciate your help.

Thanks for the reply Luis, I'm getting closer. Currently I have:

SELECT Distinct(Projects)

FROM Projects

LEFT JOIN ProjTime

ON Projects.Group=ProjTime.Group;

This shows all the Projects. How would I change the On Clause to grab all...

Thanks dmc that worked perfect. Would you know how I could limit the rank just to the first 10? Like just use the Rank on the first ten that I...

Thanks SS I appreciate it.

I'm running this query from Sharepoint, so I'm unable to mess with the tables. How would I do this with concatenation? Basically I'm doing a select statement and grabbing two...