Syntax Error Help

Copper Contributor

I am trying to get data from 5 tables to show as one and if I just limit it to 2 tables this works, but when I add the further columns to select and the further tables to get the data from it fails.

I am new to SQL and this is a massive learning curve for me. Please can someone sort this statement for me:

SELECT
A.ID,
A.EXTERNAL_IDENTIFIER,
A.FIRST_NAME,
A.LAST_NAME,
A.BIRTH_DATE,
B.STATE_PROVINCE_ID,
C.ASSISTANCE_DOG_NAME_8,
C.DATE_OF_BIRTH_9,
C.COLOUR_11,
D.INVISIBLE_DISABILITIES_142,
D.NON - VERBAL_148,
D.HEARING_IMPAIRMENT_143,
D.SIGHT_LOSS_144,
D.BLADDER_BOWEL_WEAKNESS_ILLNESS_145,
D.MOBILITY_146,
E.END_DATE,
E.MEMBERSHIP_TYPE_ID
FROM
`CiviCRM-3134371907`.civicrm_contact A,
`CiviCRM-3134371907`.civicrm_address B,
`CiviCRM-3134371907`.civicrm_value_assistance_do_2 C,
`CiviCRM-3134371907`.civicrm_value_medical_condi_3 D,
`CiviCRM-3134371907`.civicrm_membership E
WHERE
A.ID = B.ID,
A.ID = C.ENTITY_ID,
A.ID = D.ENTITY_ID,
A.ID = E.CONTACT_ID;

 

Update: It says the error is in the WHERE statement, but I don't know how to fix it

0 Replies