Index 'UNIQUE'

[Ruslan Zasukhin]

on 11/4/03 13:41, Gregoire William at wgregoire at paris.mediagerance.com
wrote:

> Hello!
> 
> (Ruslan, this msg follows the one i just sent you)
> 
> Why 
> SELECT T1.IdOne, T2.IdTwo, T2.IdThree
> FROM T1, T2
> WHERE T1.IdOne = T2.IdOne
> 
> will give me duplicates if T1.Idone is defined not_nullable/indexed and
> disctinct one if T1.IdOne is defined  not_nullable/indexed/UNIQUE ?
> 
> Is it my light SQL knowledge or is there a 'problem' ?

Hi Gregoire,

It needs to see your data in tables.

If I can do this on db you have sent me, ok.

If no, send me other db also.

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------