Query Question

[=C-Black=]

Hi All,
I found this statement :
Select ID As xyz_ID_xyz, CustomerName As xyz_DispExpr_xyz,
CustomerName From dbComp Order By ID
But I cannot understand "xyz_ID_xyz" and "xyz_DispExpr_xyz".
May I trouble you to explain it to me or introduce any web site for me
please?
thank you

 

[Arvi Laanemets]

Hi

Select OldFieldName1 As NewFieldName1, Expression(OldFieldName2) As
NewFieldName2, ...

It renames selected field or expression based on field(s) with new name. In
your case in returned result are columns As xyz_ID_xyz and As
xyz_DispExpr_xyz instead of ID and CustomerName


Arvi Laanemets

 

[=C-Black=]

thank you , i got it

Hi

Select OldFieldName1 As NewFieldName1, Expression(OldFieldName2) As
NewFieldName2, ...

It renames selected field or expression based on field(s) with new name. In
your case in returned result are columns As xyz_ID_xyz and As
xyz_DispExpr_xyz instead of ID and CustomerName


Arvi Laanemets