Can someone help 'cos I'm a bit new to this whole database stuff. I've used Access to generate an SQL query which I now intend to replicate in MySQL (the query is shown below). However, I keep getting an error when I try and design it in MySQL. Can anyone tell me how to port this Access query to MySQL successfully?
SELECT traders.id, traders.name, fresh_produce.description, fresh_produce.phone
FROM (Bakery INNER JOIN traders ON Bakery.id = traders.id) INNER JOIN fresh_produce ON traders.id = fresh_produce.trader_id;
Thanks for any help,