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

On Database » Microsoft Access

1,049 words with 3 Comments; publish: Fri, 04 Jan 2008 17:30:00 GMT; (25093.75, « »)

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?

All Comments

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.:

      [tblA].[contractnum]

      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