Please help with syntax !!!

[Zbigniew Szczesny]

Hello !

This is a syntax taken from MS Access:

SELECT messages.message_id, messages_1.message_id
FROM messages AS messages_1 INNER JOIN (messages INNER JOIN connections ON 
messages.message_id = connections.parent) ON messages_1.message_id = connections.child
ORDER BY messages.message_id, messages_1.message_id

For whatever reason this syntax is not valid for MySQL.

Please - help me to write the right equivalent one.

Thank you for your help !
Ziggi