SqlDbx
You are not logged in.
Pages: 1
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
Offline
Yes, you are right. Aliases should be added for all columns. This will be fixed in a next release.
Offline
Pages: 1