Query Question

  • Thread starter Thread starter =C-Black=
  • Start date Start date
C

=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
 
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
 
thank you , i got it

Arvi Laanemets said:
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
 
Back
Top