2 table Query Error

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
 
K

Ken Snell [MVP]

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