Originally Posted by pauldun170
Whats the relationships between the tables?
Team has many athletes
Athlete has one team
What is "entry" table?
I actually need to join four tables but that wasn't working so I tried three and that didnt work either.
For simplicity sake I left out the join with the forth table since the join with three tables yielded basically the same error I figured once I sorted the three table join then the forth would come off without a hitch.
The Entry table would used for the forth join with an Event table
I was getting an ODBC error in PHP. I am reading from an Access file that was produced by another program.
Seems like Access required some weird parenthesis.
INNER JOIN Team
ON Team.[Team_no] = Athlete.[Team_no])
INNER JOIN Entry
ON Entry.[Ath_no] = Athlete.[Ath_no])";
Thanks for taking a look guys.