MySQL #1054 - Unknown column 'masterdata_hyung_event.eventId' in 'on clause' on deep join tables So, I have this query
SELECT * FROM hyung

LEFT JOIN masterdata_hyung_description ON hyung.descriptionId = masterdata_hyung_description.hyungDescriptionId

CROSS JOIN masterdata_hyung_description ON masterdata_hyung_description.eventId = masterdata_hyung_event.eventId

which return #1054 - Unknown column 'masterdata_hyung_event.eventId' in 'on clause'.
I have those three tables, they are (i think) is already related with foreign key. More less like:
table hyung fk with masterdata_hyung_description, and masterdata_hyung_description fk with masterdata_hyung_event. What I want is how can I relate all of them so I can grab data from masterdata_hyung_event from table hyung?. Thank you
EDIT: here's the link for dump sql. Thank you.
After full days my noob brain tried to work hard, I've found my solution.
SELECT * FROM hyung, masterdata_hyung_description #this

JOIN masterdata_hyung_event ON masterdata_hyung_description.eventId = masterdata_hyung_event.eventId #and this

WHERE hyung.Taket = '1822171' AND masterdata_hyung_description.hyungDescriptionId = hyung.descriptionId

Not tested in multiple results tho (but it should), but hopefully it works too. Thanks