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

[SoftIl]

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

Is there any other way to change the column name in the result table?
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?


Best regards,
Carsten


----- Original Message ----- 
From: "Ruslan Zasukhin" <sunshine at public.kherson.ua>
To: <valentina at lists.macserve.net>
Sent: Friday, June 03, 2005 11:39 AM
Subject: [Norton AntiSpam] Re: Re[2]: How can I use the "AS" Operator in an 
SELECT-Statement


> On 6/3/05 10:22 AM, "Ivan Smahin" <IvanSmahin at public.kherson.ua> wrote:
>
>> Hello SoftIl,
>>
>> Friday, June 3, 2005, 9:00:28 AM, you wrote:
>>
>> S> Hi Ivan,
>> S> thanks for your very fast answer.
>> S> But it dosen't work. :-(
>>
>> S> I tried it in ViSQL:
>> S> SELECT record_id AS 'recIDBetrieb' FROM betriebe   --> retuns 0 
>> records
>> S> SELECT record_id  FROM betriebe  --> returns 7 records
>>
>> S> If I try it in Valentina Studio, I get the Kernel error 603 return.
>>
>> Very strange. I just tried it self and got correct result.
>> Anycase I don't see any relation between "AS" and record count in the 
>> result.
>> Would you be so kind to send me "create table" script or database or 
>> something
>> else
>> for reproducing this problem?
>
> AS work only in 2.0
>
>
> -- 
> 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]
>
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>