SELECT DISTINCT (another question)

[Ruslan Zasukhin]

on 2/10/03 7:49 PM, Eric Forget at forgete at cafederic.com wrote:

> I have another question with the same tables, with these data:
> 
> A   RecID   Name        ptr_b
>   -----   -------     -----
>   1       NameA1      1
>   2       NameA2      1
>   3       NameA3      3
> 
> B   RecID   Name
>   -----   -------
>   1       NameB1
>   2       NameB2
> 
> 
> With this query:
> 
>   SELECT RecID, Name FROM A WHERE ptr_b = 1
> 
> I got just:
> 
>   RecID   Name
>   -----   ----
>   1       NameA1
> 
> Why I do not get the "1 NameA2" and how can I get it? What it is weird is
> that if query:
> 
>   SELECT RecID, Name FROM A WHERE ptr_b >= 1 && ptr_b <= 1
> 
> I got what I want:
> 
>   RecID   Name
>   -----   ----
>   1       NameA1
>   2       NameA2

Eric,

Try rebuild index. Trash .ind file.

And/Or open this db in VAPP, and try to do search on ptr_b = 1
To do this press cmd+F and enter 1 in the EditField of ptr_b field


-- 
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://listserv.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------