rick
02-24-02, 17:26
| How come the below statement works with a MS Acces but not with Mysql? Is there a way to write a statement in mysql which does the same thing? SELECT * FROM (SELECT FOR_ID, FOR_NAME, FOR_AUTHOR, FOR_DATE, FOR_DESCRIPTION, (SELECT COUNT (*) FROM MESSAGES WHERE MESSAGES.FOR_ID = FORUMS.FOR_ID) AS NO_TOPIC, (SELECT COUNT (*) FROM REPLIES WHERE REPLIES.FOR_ID = FORUMS.FOR_ID) + NO_TOPIC AS NO_POST, (SELECT MAX (REP_DATE) FROM REPLIES WHERE REPLIES.FOR_ID = FORUMS.FOR_ID) AS LAST_POST FROM FORUMS) ORDER BY LAST_POST DESC |