[VNET] Big Problem with select over 2 tables

[Ruslan Zasukhin]

On 6/7/05 11:43 PM, "SoftIl" <softil at onlinehome.de> wrote:

> 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.

Have you try rebuild index ?

-- 
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]