mysql - Multiple table inner join not showing any results -

mysql - Multiple table inner join not showing any results -

i'm using visual studio sql database inner bring together 3 tables 1 main table.

the main table event , pk_eventsid linked fk_eventsid of other 3 tables (studentcompetition, immersiontrip, industrycollaboration)

i tried using inner bring together 2 tables (event , studentcompetition) , works, when add together table (event, studentcompetition, immersiontrip) not display though there inner join. column names appear, info doesn’t.

similar column names startdate, enddate , eventid while remaining different. know how grouping similar column names

i'm planning bring together more 10 tables search function.

sql query

select event.eventname, event.eventid, studentcompetition.competitionname, immersiontrip.immersionname event inner bring together studentcompetition on event.eventid = studentcompetition.eventid inner bring together immersiontrip on event.eventid = immersiontrip.eventid

mysql sql visual-studio-2010 join