Custom Field Name in select statement

[joseph]

Is there a way I can return a custom field name (based on data in another
table) using a select statement as follows:

Select Cat1Code as (Select CatCode From Category)
from Test

I know I can use:
Select Cat1Code as HTL
FROM Test

but I want the HTL 'alias' retrieved from another table

[Wayne Niddery (TeamB)]

"joseph" <pe...@euroweb.net.mt> wrote in message
news:487488b3$1...@newsgroups.borland.com...

>
> Is there a way I can return a custom field name (based on data in another
> table) using a select statement as follows:
>
> Select Cat1Code as (Select CatCode From Category)
> from Test

No. Values are values, meta names are meta names.

You can select the alias as a separate field and then deal with it in the
application:

Select Cat1Code, (Select CatCode From Category) as CatName
from Test

--
Wayne Niddery - TeamB (www.teamb.com)
Winwright, Inc. (www.winwright.ca)