[VNET] Big Problem with select over 2 tables

[SoftIl]

Hi Ruslan,
> Sorry, I have not understand.
No  problem, my english isn't the best.

> You do join using condition
>    c.record_id = s.masterRec_id)
Correct.
>
> So of course columns
>    SELECT c.record_id, s.record_id,
>
> Show you the same values.
> Because YOU ask for this.
That's right.
I get the same values, but the dataBase value for s.record_id is not the 
same as the dataBase value for c.record_id!
Both values are different in the dataBase.

Best regards
Carsten

----- Original Message ----- 
From: "Ruslan Zasukhin" <sunshine at public.kherson.ua>
To: <valentina at lists.macserve.net>
Sent: Tuesday, June 07, 2005 8:04 PM
Subject: [Norton AntiSpam] Re: [VNET] Big Problem with select over 2 tables


> On 6/7/05 4:47 PM, "SoftIl" <softil at onlinehome.de> wrote:
>
> Hi Carsten,
>
>> Hi Ruslan,
>> I still fighting with my alias problem.
>> I solved the alias problem inside my code,
>> but now I found a new big problem:
>>
>> If I use this statement:
>>
>> 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 get the same values in both record_id-columns.
>> The column with the stable recordID (s.record_id) contains the recordID 
>> from
>> the company record (c.record_id).
>>
>> What I have to do, that I get the recordID form the company record and 
>> from
>> the stable record in the same result record?
>
> Sorry, I have not understand.
>
> You do join using condition
>    c.record_id = s.masterRec_id)
>
> So of course columns
>    SELECT c.record_id, s.record_id,
>
> Show you the same values.
> Because YOU ask for this.
>
> Or you ask about other problem?
>
>
> -- 
> 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
>