hey all.

i've gone over various threads with the error and most end up being placement of brackets, etc.

I can't seem to figure this out, and i'm sure its really simple.

First off, this is going to an Access Database that has linked tables tied to an ORACLE DB.


So here is my SQL string that is throwing the error.

Code:
strSQL = "SELECT SYSTEM.EMAIL" & _
"FROM CUSTOMER INNER JOIN SYSTEM" & _
"ON CUSTOMER.ID = SYSTEM.ID" & _
"WHERE (((CUSTOMER.STATE) = '" & mySt & "')) "
It;s basically pulling an email address based on the state in the customer table matching mySt variable. using ID's as the comparison keys, or primary key if you will.

I tried the following also, with no success.

Code:
FROM CUSTOMER INNER JOIN (SYSTEM ON CUSTOMER.ID = SYSTEM.ID)
not really sure why the error...since i pulled the syntax directly from SQL view in the access database, after creating a query in design view. only difference is that i added in a variable mySt , instead of picking one myself. i've also viewed the mySt variable just before the sqlStr gets ran into a record set, and its contents matches fine.


any ideas?