Hi.
In Dynamics CRM, how do I create record relationships such as linking a contact to an account?
Gordon
Creating Relationship Links in Dynamics CRM
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Creating Relationship Links in Dynamics CRM
Please describe in more details what exactly you want to do.
If you want to select data from Contacts and related Accounts then you can use the following query:
If you want to select data from Contacts and related Accounts then you can use the following query:
Code: Select all
SELECT c.*, a.*
FROM contact c
LEFT OUTER JOIN account a ON c.parentcustomerid = a.accountid