Problem with aliases
Posted: Tue 31 Jul 2007 10:31
select a.adresse,
b.adressebez,
a.referenzart,
c.referenzbez,
a.referenzadresse,
d.referenzadressebez
from mk_adressenreferenzen a,
st_adressen b,
mk_referenzen c,
st_adressen d
where a.adresse = b.adresse
and a.referenzart = c.referenzart
and a.referenzadresse = d.adresse
causes an error ORA-00918. WHY ??????
b.adressebez,
a.referenzart,
c.referenzbez,
a.referenzadresse,
d.referenzadressebez
from mk_adressenreferenzen a,
st_adressen b,
mk_referenzen c,
st_adressen d
where a.adresse = b.adresse
and a.referenzart = c.referenzart
and a.referenzadresse = d.adresse
causes an error ORA-00918. WHY ??????