Parse error

[daone]

Hi i'm getting a pass error when i try to join another table to table customers

 

here my code

 

select c.customers_id, c.customers_gender, c.customers_firstname, c.customers_lastname, c.customers_dob, c.customers_email_address, a.entry_company, a.entry_street_address, a.entry_suburb, a.entry_postcode, a.entry_city, a.entry_state, a.entry_zone_id, a.entry_country_id, m.neck_measurement, m.chest_measurement, m.sleeve_measurement, m.waist_measurement, m.outer_leg_measurement, m.inside_leg_measurement, m.back_leg_measurement, m.top-of_shoulder_measurement, m.bust_measurement, m.hip_measurement, c.customers_telephone, c.customers_fax, c.customers_newsletter, c.customers_default_address_id from " . TABLE_CUSTOMERS . " c left join " . TABLE_ADDRESS_BOOK . " a on c.customers_default_address_id = a.address_book_id where a.customers_id = c.customers_id and c.customers_id = '" . (int)$HTTP_GET_VARS['cID'] . "'")" left join ". TABLE_MEASUREMENT . " m on c.customers_default_measurement_id = m.measurement_id where m.customers_id = c.customers_id and c.customers_id = '" . (int)$HTTP_GET_VARS['cID'] . "'"

 

any help would be appreciated thanx.