Using Aliases to shorten stuff

mdweezer · Jun 16, 2004

How do I go about creating Aliases to shorten the length of stuff in a SQL query?

Thanks

SkipVought · Jun 16, 2004

Hi,

Code:

Select A.Field1, B.Field2...
From MyTable1 A, MyTable2 B
Where A.FieldA=B.FieldA...

Is this what you meant?

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

mdweezer · Jun 16, 2004

It might be... I will give that syntax a try

SkipVought · Jun 16, 2004

I normally try to use something a bit more descriptive like

Code:

Select MAT.Field1, ORD.Field2...
From Material MAT, Orders ORD
Where MAT.FieldA=ORD.FieldA...

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884