SQL does not like field existing in three tables

[amerifax]

I get an error when I use the run command in Access 2007 query.

FROM ((permit INNER JOIN BUILDER ON permit.BLD = BUILDER.BLD) INNER JOIN SUB ON permit.SB = SUB.SB) INNER JOIN CITY ON permit.SC = CITY.SC

Error:
The specified field '[SC]' could refer to more than one table listed in the from clause of your SQL statement.

It is true that the "SC" does exist in three of the tables. We are porting over from dBase IV, which never gave us this problem, so evidently there is something that we have to understand.

Bob

 

[John Big Booty]

The code as you have presented it has no Select clause ie. you have not specified what it is you wish to return. You only have a Where clause