|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
 |
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
|
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
Dev Articles Community Forums Sponsor:
|
|
|
|
#1
April 6th, 2005, 03:46 AM
|
|||
|
|||
|
Passthrough Query doesn't like JOIN's
Hi guys,
I have an Access query which is a Passthrough Query to an Oracle database. When I try and to 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 claise of your SQL statement". Anyone know how, if possible, I can get around this? Cheers Rob
|
|
#2
June 3rd, 2005, 07:48 AM
|
|||
|
|||
|
It sounds as though at least one of your field names is in more than one table. Prefix every field name in your query with the required table name, e.g TableName.FieldName
Hope that helps
|
|
| Viewing: Dev Articles Community Forums > Databases > Microsoft Access Development > Passthrough Query doesn't like JOIN's |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
