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
#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:
hyung fk with
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.