create a select statement for the funding table using a rownumber field so each project has a number based on the Project ID.

Then do a straight select statement joining the 2 tables with a left outer join based on the ID field and in the select add a case statement that corresponds to all the possible numbers within the rownumber.

Jason.