Hi,
I try to do what seems to be totally simple, but it fails. If I query a view that contains renamed columns without any qualifier like
SELECT * FROM myview
it displays everything. If however I do
SELECT reanmedviewcolumn FROM myview
It tells me column does not exist which in fact does. I can query any non-renamed columns. But the renamed ones I can neither call by their original name, not int he SELECT part nor in the WHERE clause.
I can neither leave the view with just the original names as it's a selfjoin.
What do I need to do?
Thanks
Alex