Trying to query multiple tables

[ma701sd]

Hi,

Im trying to perform this query but I keeopetting an error saying:
ODBC Error Code = S1000 (General error)


[Microsoft][ODBC Microsoft Access Driver] The specified field 'UserName' could refer to more than one table listed in the FROM clause of your SQL statement.



The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (8:3) to (8:50).


The query I'm trying to perform is :

SELECT UserName
FROM (((Users INNER JOIN Links ON Users.UserName = Links.UserName)
INNER JOIN Section1 ON Users.UserName = Section1.UserName)
INNER JOIN Section2 ON Users.UserName = Section2.UserName)
INNER JOIN Heading ON Users.UserName = Heading.UserName

WHERE (((Heading.UserName)='#client.username#') AND
((Links.UserName)='#client.username#') AND
((Section1.UserName)='#client.username#')AND
((Section2.UserName)='#client.username#'));

This has worked for other queries so why will it not work here?

Is my query wrong?
Cheers
Sam...

 

[AMayer]

Change the first line of your query to be:

SELECT Users.UserName

Since you have a UserName column in all of the tables used in your query, Access does not know which one you want and will return that error unless you specify. Andrew