Re: [SQL] A table with two names or table alias

2008-07-25 Thread Igor Neyman
t: [SQL] A table with two names or table alias Can I create a table name alias? What i want is to access the same table with two different names. An example: I've the table CITY with fields code and name. I want to know if i can create an alternative name to table CITY, like LO

Re: [SQL] A table with two names or table alias

2008-07-25 Thread A. Kretschmer
am Fri, dem 25.07.2008, um 14:12:47 +0200 mailte Tk421 folgendes: >Can I create a table name alias? > >What i want is to access the same table with two different names. An > example: > >I've the table CITY with fields code and name. I want to know if i > can create an alternative n

[SQL] A table with two names or table alias

2008-07-25 Thread Tk421
Can I create a table name alias? What i want is to access the same table with two different names. An example: I've the table CITY with fields code and name. I want to know if i can create an alternative name to table CITY, like LOCATION, to make possible these two sentences: