Error No: 1054 - MySQL error Unknown column 'c.occasion_id' in 'on clause'
Query:
SELECT * FROM
m_contact c
LEFT JOIN m_occasion o ON o.occasion_id=c.occasion_id
WHERE
bedrijf_id=1
ORDER BY c.`date` DESC
#0 /var/www/tip4.efarm.nl/public_html/classes/class.contact.php(14): Mysql->execute('SELECT * FROM\n\t...')
#1 /var/www/tip4.efarm.nl/public_html/controllers/admin.php(113): Contact->getBedrijf(1)
#2 /var/www/tip4.efarm.nl/public_html/controllers/admin.php(136): Admin->reacties()
#3 /var/www/tip4.efarm.nl/public_html/controllers/admin.php(140): Admin->__construct(Object(mysqli))
#4 /var/www/tip4.efarm.nl/public_html/index.php(8): include_once('/var/www/tip4.e...')
#5 {main}