Ed,

I can't find your insert statement of your query into the temp table. If the temp table is empty, you won't get any results when selecting on the organisationid.

Marc