Subject | Firebird: the ambiguity database |
---|---|
Author | saharacamel01 |
Post date | 2002-11-18T08:47:21Z |
Doing a test to replace Interbase with Firebird 1.0 lots of my
queries cause ambiguity errors. (SQL error -204). Most of them I
could solve myself but with this one I need help.
select pa.paneelnr, pa.beslagnr, pa.positie, pa.getoond, a.artikelnr,
a.omschrijving1, a.omschrijving2, a.specificatie, a.prijs
from paneelart pa left outer join artikel a on pa.beslagnr =
a.beslagnr
where pa.paneelnr = :Paneelnr
order by pa.positie
The ambiguity is on beslagnr. Both tables have a field 'beslagnr'.
Thanks in advance.
queries cause ambiguity errors. (SQL error -204). Most of them I
could solve myself but with this one I need help.
select pa.paneelnr, pa.beslagnr, pa.positie, pa.getoond, a.artikelnr,
a.omschrijving1, a.omschrijving2, a.specificatie, a.prijs
from paneelart pa left outer join artikel a on pa.beslagnr =
a.beslagnr
where pa.paneelnr = :Paneelnr
order by pa.positie
The ambiguity is on beslagnr. Both tables have a field 'beslagnr'.
Thanks in advance.