Re: [GENERAL] how to alias a table

2010-06-13 Thread fdd sds
On Jun 13, 10:07 am, m...@webthatworks.it (Ivan Sergio Borgonovo) wrote: > I'm refactoring some code and I'll find helpful to be able to alias > tables. > > What I'd like to do would be to refer to the same table with an > alias in the code and later substitute the alias with an actual VIEW. > > Of

Re: [GENERAL] how to alias a table

2010-06-13 Thread Tim Landscheidt
Ivan Sergio Borgonovo wrote: > I'm refactoring some code and I'll find helpful to be able to alias > tables. > What I'd like to do would be to refer to the same table with an > alias in the code and later substitute the alias with an actual VIEW. > Of course I could define a view as > select *

[GENERAL] how to alias a table

2010-06-13 Thread Ivan Sergio Borgonovo
I'm refactoring some code and I'll find helpful to be able to alias tables. What I'd like to do would be to refer to the same table with an alias in the code and later substitute the alias with an actual VIEW. Of course I could define a view as select * from original_table right from the start bu