SQL-Problem Inner join
hejJeg har nedenstående SQL til en access DB og kører...
men jeg kan ikke få den til at køre i mySQL.
Kan nogen hjælpe mig her.
SELECT
FORUM_FORUM.F_SUBJECT,
FORUM_TOPICS.FORUM_ID,
FORUM_TOPICS.TOPIC_ID,
FORUM_TOPICS.CAT_ID,
FORUM_MEMBERS.MEMBER_ID,
FORUM_MEMBERS.M_NAME,
FORUM_TOPICS.T_SUBJECT,
FORUM_TOPICS.T_MESSAGE,
FORUM_TOPICS.T_DATE,
FORUM_MEMBERS.M_SIG
FROM FORUM_FORUM
INNER JOIN (FORUM_MEMBERS INNER JOIN FORUM_TOPICS ON FORUM_MEMBERS.MEMBER_ID = FORUM_TOPICS.T_AUTHOR)
ON (FORUM_FORUM.FORUM_ID = FORUM_TOPICS.FORUM_ID) AND (FORUM_FORUM.CAT_ID = FORUM_TOPICS.CAT_ID)
WHERE
FORUM_FORUM.FORUM_ID=43
and FORUM_TOPICS.T_STATUS < 2
ORDER BY FORUM_TOPICS.T_DATE
DESC
Jeg får denne fejl :
You have an error in your SQL syntax near '(FORUM_MEMBERS INNER JOIN FORUM_TOPICS ON FORUM_MEMBERS.MEMBER_ID = FORUM_TOPICS' at line 1
