Page 1 of 1

Problem with aliases

Posted: Tue 31 Jul 2007 10:31
by mesch181
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 ??????

Posted: Wed 01 Aug 2007 10:17
by Plash
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.