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.

 All Forums
 Other Forums
 MS Access
 Passthrough Query doesn't like JOIN's

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?

Cheers

Rob

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.
Go to Top of Page

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.
Go to Top of Page
   

- Advertisement -