How Do I convert this?

[Anon]

Hi:

I had to convert a MS Access DB to mySQl. I've done that with all the fields being the same type, name,....

However, I realize the following sql statement does not work in mySQl. Could you help me convert it please?

SELECT Alphabets.Alphabet, Category.Category, Sections.Section FROM Alphabets INNER JOIN (Category INNER JOIN Sections ON Category.Cat_ID = Sections.Cat_ID) ON Alphabets.Alpha_ID = Category.Alpha_ID;

Thanx

[heri-setyono]

Try this :

SELECT Alphabets.Alphabet, CS.Category, CS.Section FROM Alphabets INNER JOIN (Category INNER JOIN Sections ON Category.Cat_ID = Sections.Cat_ID) CS ON Alphabets.Alpha_ID = CS.Alpha_ID;

[crimaniak]

Why JOINs?

SELECT Alphabets.Alphabet, Category.Category, Sections.Section FROM Alphabets,Category,Sections WHERE Category.Cat_ID = Sections.Cat_ID AND Alphabets.Alpha_ID = Category.Alpha_ID;