Convert SQL to MySQL statement?

[Quintios]

I need to convert this MS Access generated SQL statement into something MySQL likes:

SELECT 'phpbb_forums.forum_id', 'phpbb_posts_text.post_text'
FROM ('phpbb_forums' 
INNER JOIN 'phpbb_posts' ON 'phpbb_forums.forum_id' = 'phpbb_posts.forum_id') 
INNER JOIN 'phpbb_posts_text' ON 'phpbb_posts.post_id' = 'phpbb_posts_text.post_id'
WHERE ((('phpbb_forums.forum_id')=10));

It gives me this error:

You have an error in your SQL syntax near ''phpbb_forums' INNER JOIN 'phpbb_posts' ON 'phpbb_forums.forum_id' = 'phpbb_post' at line 1

I don't know what the error is... I am entering this statement into phpmyadmin.

Thanks in advance for your help! Onwards,

Q-

 

[Quintios]

Never mind. I got it to work by taking out all the quote marks:

SELECT phpbb_forums.forum_id, phpbb_posts_text.post_text
FROM (phpbb_forums INNER JOIN phpbb_posts ON phpbb_forums.forum_id = phpbb_posts.forum_id) INNER JOIN phpbb_posts_text ON phpbb_posts.post_id = phpbb_posts_text.post_id
WHERE (((phpbb_forums.forum_id)="10"));

Onwards,

Q-