2 table Query Error

  • Thread starter Thread starter GRCC
  • Start date Start date
G

GRCC

The specified field <number> could refer to more than one table listed in
the FROM clause of your SQL statement. (Error 3079)
This is the error message I get. I have a query that works nicely pulling
info from one table. I need to add a second table from the same DB to pull 2
more items. It is a Country club member accounting database. When I add the
2nd table and specify the 2 fields I need (the relationships are correct,
member ID to member ID) I get the afore memtioned error message. The 2
tables both have a number feild (same data) is this the problem? I have
tried adding the number field a second time, each one indicating which table
to pull from. So why ? I am beginning to think that the program is flawed
and poorly written because first theused number as a field, but to make it
worse they used number as a field in 2 different tables. Any Ideas?
Thanks So Much
GRCC
 
Post the SQL statement of the query that is giving you this error. Likely
you need to add the table name in front of the field name in a WHERE clause
or an ORDER BY clause.
 
Back
Top