Hi all:
I think my problem is pretty simple, but I can't figure it out!
I have three tables that are joined:
Alphabets: AlphaID(PK), Alphabet
Category: CatID(PK) , CategoryName, AlphaID
Business: BusID(PK), BusName, CatID
==
Basically what I need as an end result is to list Alphabets, the categories under each letter, and the businesses under each category.
The initial DB was designed in MSAccess and the query created in it (which uses innerjoins) works perfectly. However when I created the same DB in mySQL and ran the query I get an SQL error.
Any help is greatly appreciated.
I also need to mention that when I ran innerjoins on two tables things did work fine.
I'm lost!
