Linking Tables SQL

[Gilberto Lawas via AccessMonster.com]

Can someon please break down this code for me. I'm a little confused about
what it's supposed to do.


SELECT MdlLst.ID AS xyz_ID_xyz, MdlLst.MdlNum AS xyz_DispExpr_xyz,
MdlLst.MdlNum
FROM MdlLst
ORDER BY MdlLst.MdlNum;

r/s
G.Lawas

 

[Douglas J. Steele]

It's the SQL required to return 3 fields from the table MdlLst, sorted by
the MdlNum field. The field named ID will appear as though it was named
xyz_ID_xyz, and the field MdlNum will appear as though it was named
xyz_DispExpr_xyz.

By itself, though, it doesn't mean much.

 

[Gilberto Lawas via AccessMonster.com]

Thank You.

I have this in one of my tables. But it doesn't seem to be working right
b/c I want the Model numbers to be displayed not the ID numbers. But I
can't seem to work it.

got andy advice?

r/s
G.Lawas