SqlDbx Forum

rony

Member

Query whith alias of a Table

When I have a Query whith alias of a Table and I select more than one 
attributes in the suggest, SqlDBX dosen't show the alias

ie:

Select T1.--------------------  T2.--------------------
              - CustomerId         -     - PostCode            -
              - CustomerName    -     - LocId                  -
            - PostCode           -     -                          -   
              --------------------     --------------------           
From Customer T1
    Inner Join PostCode T2 on T1.PostCode = T2.PostCode

When I Select the 5 Atributes I shoud have this query:

Select T1.CustomerId,  T1.CustomerName, T1.PostCode, T2.PostCode, T2.LocId
    Inner Join PostCode T2 on T1.PostCode = T2.PostCode

But SqlDbx Show Me This:

Select T1.CustomerId,  CustomerName, CustomerPostCode , T2.PostCode, LocId       
    Inner Join PostCode T2 on T1.PostCode = T2.PostCode

The las Query have one error

sqldbxhelp

Administrator

Re: Query whith alias of a Table

Yes, you are right. Aliases should be added for all columns. This will be fixed in a next release.