Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

specified field could refer to more than one table listed...

Status
Not open for further replies.
g33kgrrl

g33kgrrl

Programmer
Jun 1, 2007
5
US
I have a query named qry_scorecard that joins a table and another qry - it runs fine. (I have scoured the SQL and it does not have duplicate field names.)

My second query (qry_scorecard_TEMP) retrives data from the original qry_scorecard. It is the only table or query being accessed. I keep getting the message that a field could refer to more than onr table listed in the FROM statement. Well, there is only one qry in the FROM statement. I even deleted the offending column(field) from the original qry_scorecard to test if there were two columns with the same name - I get the same error.

Any ideas?
 
Sort by date Sort by votes
I ended up renaming (with an alias) the offending colmn in both of the queries and it worked. How stupid. Gawd -I love programming some days......
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

serino
  • Locked
  • Question
Delete From Table
Replies
1
Views
291
Andrzejek
Andrzejek
TheresAlwaysAWay
  • Locked
  • Question
Union query provides different reslt than when summing the combined queries individually 1
Replies
12
Views
421
TheresAlwaysAWay
TheresAlwaysAWay
TrekBiker
  • Locked
  • Question
Records in one table not in another 1
Replies
3
Views
150
Andrzejek
Andrzejek
MDGarcia
  • Locked
  • Question
Error Could not delete from specified tables 2
Replies
14
Views
449
MDGarcia
MDGarcia
JayRo71
  • Locked
  • Question
Unable to sort date field
Replies
4
Views
146
JayRo71
JayRo71

Part and Inventory Search

Sponsor

Back
Top