>>>>Nothing,
>>>>Remove aggregate functions and GROUP BY and you will see what happened.
>>>>Some records will be doubled just becuase you added another table.
>>>>Maybe you have more than one record for TipID and Fundtype = 'RTA' in TIP_ApprovedFunding
>>>
>>>Borislav - You are right. The relationships are:
>>>RTA_Element is parent
>>>TIP_Projects is child
>>>TIP_ApprovedFunding is child of TIP_Projects
>>>TIP_Ledger is child of TIP_Projects
>>>
>>>Is there no solution to putting this together? My original code had one of the columns derived by a second select but I can't seem to make that work either.
>>
>>Take a look at this blog post explaining the problem and a solution
>>
>>http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/aggregates-with-multiple-tables
>
>:o)
>I always try to stick to 2000 syntax (just because of 3 clients)
>They definitely don't want to upgrade.

BTW,

http://blogs.lessthandot.com/index.php/DataMgmt/DBAdmin/MSSQLServerAdmin/sql-server-2008-r2-sp2

I am installing it right now.