Tags: access, clause, contractnum, database, error, field, microsoft, mysql, oracle, querythe, refer, running, specified, sql, table
The specified field could refer to more than one table listed in the FROM clause
I am getting this error after running my query
The specified field [contractnum] could refer to more than one table listed in the FROM clause of your SQL statement. (Error 3079)
my contractnum is a one to many to another table.
how do i fix this?
Leave a comment...
- 3 Comments
- You have (accidentally) posted this question in the Access Articles section. This is NOT an article.
I'm moving this to the main Access questions forum.
MODERATOR.#1; Fri, 04 Jan 2008 17:31:00 GMT
- I suspect this is quite straightforward, but posting a copy of the SQL that is triggering the error message would prove helpful.
From there we can tell you precisely what to fix.#2; Fri, 04 Jan 2008 17:32:00 GMT
- You'll have to "qualify" the field [contractnum] as it's apperently part of two tables.
Let's assume you have the tables tblA and tblB, then use e.g.:
When it's tblA having the needed value. For a full (INNER) join the table won't matter, but when you have an outer (LEFT or RIGHT) join (there's an arrow displayed instead of a line), then make sure you use the "master" table to qualify the field
Nic;o)#3; Fri, 04 Jan 2008 17:33:00 GMT