|Created ||06/10/2010 04:30 AM by Johnny Jiang.|
|Modified||06/10/2010 04:36 AM by Johnny Jiang.|
Firstly, I assume you have 2 profiles already. One for Contacts-DB, and the other one for Contracts-DB.
In the profile for Contracts-DB, field and title lists could be like below:
Field list: CompanyID, ContractType, Product, 1
Title list: Key, Contract Type, Product, DataSet
In the profile for Contacts-DB, field and title lists could be like below:
Field list: myID, COmpanyType, 2
Title list: Key, Company Type, DataSet
Please note that the titles of the keys should be identical, and make sure there are matches between CompanyID and myID. For test purpose, you can simply put a string value (eg."key") in the field lists to replace CompanyID and myID to test the profiles.
There is a demo profile for XSLT in the database demonstrating how to set up Join.
Hope that makes sense. Please feel free to let us know if you have further questions and suggestions.