S
Stever
I have a query that I need to have assign an alias to the returned field
name.
SELECT Company.TypeofCompany AS Categories FROM Company;
The TypeOfCompany field refers to a lookup field in the Company table. The
problem I have is that the alias is not showing up when I run the query.
When I try assigning alias to other fields, it works fine. It only fails on
the lookup field.
Any ideas what is causing this?
Thanks
Steve
name.
SELECT Company.TypeofCompany AS Categories FROM Company;
The TypeOfCompany field refers to a lookup field in the Company table. The
problem I have is that the alias is not showing up when I run the query.
When I try assigning alias to other fields, it works fine. It only fails on
the lookup field.
Any ideas what is causing this?
Thanks
Steve