How to join three tables?

[kamy99]

Hi:

Please correct me if I'm wrong, but as far as I understand and read through articles, mySQL doesn't support sub-queries. I ask this because I've been trying to run a query on Three tables and get an error. I know my syntax well enough to know there's nothing typed wrong. When I run queries on any two tables they work.

Basically I have three tables:
Alphabets AlphaID(pk), Alphabet
Category, CatID(pk), CatName, AlphaID
Business BusID, BusName, CatID

I need the end result to look like this:

A, Airport, Ohare
A, Airport, LAX
B, Bakery, Angelo's
C, Clothing, Marshal Field
....

I've created the same tables in MSAccess too, and queried them and they work.

The query is

SELECT Alphabets.Alphabet, Category.CatName, Business.BusName
FROM (Alphabets INNER JOIN Category ON Alphabets.AlphaID = Category.AlphaID) INNER JOIN Business ON Category.CatID = Business.CatiD;

Any help is greatly appreciated.

kamy

[zhabala]

SELECT Alphabets.Alphabet, Category.CatName, Business.BusName FROM
Alphabets, Category, Business WHERE
Alphabets.AlphaID = Category.AlphaID AND
Caetgory.CatID = Business.CatID;

Maybe it will work.