Have a look at this query. Is there anyway of making the IN-statement a JOIN instead?
Yes, I'm quite new to this. Thanks in advance for any help.
SELECT * FROM company AS t1, employee AS t2 WHERE t1.id IN (SELECT id FROM multinational WHERE market = 'EMEA') AND t2.ID = t1.employee_id ORDER BY salary DESC LIMIT 0, 24