Thank you for the suggestion.
I have actually come up with a different solution
[font="Comic Sans MS"]Use Reporting
--Campaign organistion Data
GC.[CampaignID] as Campaign_CampaignID
,GC.[OrganisationName] as Campaign_OrganisationName
,D.[UniqueID] as Donor_UniqueDonorId
,D.[PPNo] as Donor_PPNo