Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
Bounty Bob
Starting Member
12 Posts |
Posted - 2005-04-06 : 04:49:36
|
Hi guys,I have an Access query which is a Passthrough Query to an Oracle database. When I try to use this query within another query containing a JOIN, I receive the error "The specified field 'query.fieldname' could refer to more than one table listed inthe FROM clause of your SQL statement".Anyone know how, if possible, I can get around this?CheersRob |
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2005-04-06 : 05:03:13
|
You may need to 'alias' a column/table to clarify which column in 2 different tables, with the exact same column name, you are referring to. |
 |
|
Bounty Bob
Starting Member
12 Posts |
Posted - 2005-04-08 : 09:18:58
|
Cheers for the response, I've followed your advice and it works fine.Thanks again. |
 |
|
|
|
|