What's wrong with my INNER JOIN

[kepardue]

Okay, I'm learning INNER JOINs for a class project using PHP, MSAccess and ODBC. I've got two tables: clients (clientID, clientName,...) and clientItems (clientID, fileDescr, approved,...).

I'm trying to temporarily merge clientName from clients into the data from clientItems. I've created this SQL statement (and confirmed that it is correct by creating it using MS Access' query builder).

SELECT clients.clientName, clientItems.fileDescr, clientItems.approved FROM clients INNER JOIN clientItems ON clients.clientID=clientItems.clientID;

However, I get a "odbc_do(): supplied argument is not a valid ODBC-Link resource in ..." error. Could someone tell me what I'm doing wrong (other than using Access instead of MySQL--I'll get to that later on ;-)).

Kenneth

[mrhappiness]

if you say you created this statement within ms access it's something that ms access should be able to do

what das [man]odbc_errormsg[/man] say?

try the statement without trailing ;

[kepardue]

Well, I've tried the statement without the ; at the end... no such luck. And, odbc_errormsg doesn't return any result when I echo it.

Any other ideas?

Thanks,
Kenneth