Problem with aliases

mesch181 · Post by **mesch181** » 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 ??????

Plash · Post by **Plash** » Wed 01 Aug 2007 10:17

We could not reproduce the problem. Please send to odac*crlab*com a complete small sample that demonstrates the problem, including script to create server objects.