Hi,
In my CRM 5.0 it doesn't work join on CRMD_PARTNER-PARNTER_NO = BUT000-PARTNER_GUID. AFAIK on 3.0 it works. Have You observed something like this?
reg.
Wojciech