Hello,
Try
SELECT messages.message_id, messages_1.message_id
FROM messages as messages_1
INNER JOIN connections
ON messages_1.message_id = connections.child
INNER JOIN messages
ON messages.message_id = connections.parent
ORDER BY messages.message_id, messages_1.message_id
or
SELECT messages.message_id, messages_1.message_id
FROM messages as messages_1, connections, messages
WHERE
messages.message_id = connections.parent
AND messages_1.message_id = connections.child
ORDER BY messages.message_id, messages_1.message_id
Regards
Jean-Claude MAES
----- Original Message -----
From: "Zbigniew Szczesny" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, July 25, 2001 5:40 PM
Subject: Please help with syntax !!!
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
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
