The point of the query is to determine the current amount invoiced for each project by using a subquery to sum the related invoices. There are other reasons this is being done in a subquery rather than just a join so I really need to figure out the subquery issue.

freaking awesome! I bang my head on the desk and tell myself I should go back to just using SQL then an answer like this makes the choice of SA feel like such a great idea. Thx...
–
PlaidFanOct 18 '11 at 0:57