Help improving this query using IN 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
Try this:

SELECT c.*, e.*
FROM company AS c
  INNER JOIN employee AS e on e.ID = c.employee_id
  INNER JOIN multinational AS m ON (m.company_ID = c.id and m.market = 'EMEA')
ORDER BY salary DESC 
LIMIT 0, 24