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
