Re: [GENERAL] Cannot query views with WHERE clause on renamed columns

Alexander Reichstadt writes: > 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

Re: [GENERAL] Cannot query views with WHERE clause on renamed columns

Alexander Reichstadt wrote > 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 tel

[GENERAL] Cannot query views with WHERE clause on renamed columns

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