[VNET] Big Problem with select over 2 tables

[Ruslan Zasukhin]

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]