hey guys so im really struggling with selecting data from 3 tables
contact
|id|name|
guest
|id|event_id|
event
|event_id|event_name|
so what ive tried to do is:
SELECT c.id,c.name,g.id,g.event_id,e.event_id FROM contact c INNER JOIN guest g ON g.id = c.id LEFT JOIN event e ON g.event_id = e.event_id
but no data appears nor any errors or notices or warning.
i want to get c.name and c.id from contact where c.id = g.id and where e.event_id = g.event_id(i need this coz im using a drop down list to select the names and display, the drop down list is populated by event_name)