Solved Alias

[Space Cowboy]

Good Morning Good People,

Can a field name be given an alias in a select statement?

 

[Minty]

Yes - you would write it in the SQL statwment as

SELECT tb_Customers.Customer_ID AS Customer_Ref_No
FROM tb_Customers;

In the query editor you would do this:

 

[Space Cowboy]

@Minty

Thank you.

 

[ebs17]

@Minty's suggestion is correct. However, when using it, you must note the following:
The assigned column alias only has an external effect and partly in the SELECT part of the query.
As a query execution is very different from running through the SQL statement from top to bottom, the column alias is still unknown for operations such as WHERE, GROUP BY, ORDER BY. In these cases, the original expression must be used.

 

[Space Cowboy]

I suppose that is why there were errors.
I went back and removed the alias from all statements.

I need to learn what is happening in what order.

 

[arnelgp]

I need to learn what is happening in what order.

you need to read the Manual first, before you can operate any machines.

 

[ebs17]

I need to learn what is happening in what order.

If you want to read a text in German - here are some thoughts I have put down:
Basics - SQL is easy (11) - Order of query processing

Grundlagen - SQL ist leicht (11) - Reihenfolge der Abfrageabarbeitung - MS-Office-Forum

SQL ist leicht (11) - Reihenfolge der Abfrageabarbeitung Microsoft Access - Code Archiv

www.ms-office-forum.net

 

[Space Cowboy]

@ebs17

Danke Eberhard,
Mein Deutsch war noch nie besonders gut, abgesehen von der Analyse guter deutscher Biere ist Doppelbock mein Favorit. Mit Hilfe eines Übersetzers konnte ich Ihren ausführlichen Beitrag lesen. Da sind einige tolle Tipps dabei. Vielen Dank, dass Sie mein Verständnis erweitert haben.