CiviCRM Community Forums (archive)

I was trying to create a relationship view following the simple example in http://forum.civicrm.org/index.php/topic,7516.0.html

but received the following error:

user warning: Column 'id' in field list is ambiguous query: SELECT id, civicrm_relationship.description AS civicrm_relationship_description, civicrm_contact_civicrm_relationship.id AS civicrm_contact_civicrm_relationship_id, display_name FROM cams_civi.civicrm_relationship civicrm_relationship INNER JOIN cams_civi.civicrm_contact civicrm_contact_civicrm_relationship ON civicrm_relationship.contact_id_a = civicrm_contact_civicrm_relationship.id INNER JOIN cams_civi.civicrm_contact civicrm_contact_civicrm_relationship_1 ON civicrm_relationship.contact_id_b = civicrm_contact_civicrm_relationship_1.id LIMIT 0, 10 in /home/webadmin/westohioumc.virtual.vps-host.net/html/modules/acquia/views/includes/view.inc on line 765.

So far the relationship integration seems very confusing. I'm trying to create a result equivalent to the following sql but have had no luck.

Here is the basic sql:

select t.name_b_a, lm.display_name
from civicrm_relationship r
inner join civicrm_relationship_type t on (r.relationship_type_id = t.id)
inner join civicrm_contact lm on (r.contact_id_a = lm.id)

Thanks