How can I use the "AS" Operator in an SELECT-Statement

[Ruslan Zasukhin]

On 6/3/05 2:58 PM, "SoftIl" <softil at onlinehome.de> wrote:

> Hi Ruslan,
>> AS work only in 2.0
> and when will V 2.0 of VNET be available?

I think 1.5-2 months yet
 
> Is there any other way to change the column name in the result table?

no

> In my real select statement I get 2 columns form 2 tables with the same
> name:
> 
> SELECT c.record_id, c.companyNumber, s.record_id, s.stableNumber from
> company c, stable s WHERE (c.companyNumber = '14587') AND (c.record_id =
> s.masterRec_id)
> 
> I've got 2 columns 'record_id' in the result table.
> How can I access to the record_id from company table and to the record_id
> from stable table?

Use access by index

    field( 3 )


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]