HELP. MySQL Syntax Incorrect
Please can someone help a newbie to MySQL?
I am trying to get data to show together from 5 tables. If I reduce it to 2 tables it works, but when I add more it tells me there is an issue with the WHERE statement.
I don't know where I am going wrong, but I need help urgently
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;