Assign Different Alias for different Tables

[zhbuyiqlik]

I have 3 tables: A, B, and C.   Each has a field called City.  I wanted to assign City from A as A.City, B as B.City and C as C.City;

I tried the following code, but the Qlik Aliased all cities as A.City.   Is there a way to limit the range of Alias?

[table A]:

Alias [City] as A.City;

SQL Select * from A;

[table B]:

Alias [City] as B.City;

SQL Select * from B;

[table C]:

Alias [City] as C.City;

SQL Select * from C;

[Anil_Babu_Samineni]

You can remove Alias everywhere it will work (Ex:  [City] as C.City)