How to track down doubloons in valentina ?

[Ruslan Zasukhin]

On 10/1/04 5:16 PM, "olivier" <vidal_olivier at yahoo.fr> wrote:

>> There general operation is GROUP BY, DISTINCT,
>> Which can compare order remove THE SAME values.
> 
> I always study the problem for the doubloons of names of company but
> the example of Beatrix is interesting.
> It can be applicable for the family names.
> 
> For example, if I want to make a search for doubloons on the name, zip,
> city:
> 
> SELECT * FROM Customers GROUP BY Name, Zip, City HAVING COUNT(*)>1
> 
> It's good, simple and fast.

Note, having cannot be used without GROUP BY


> It is damage that Valentina 1 does not understand ' HAVING '.
> 
> There a trick for to obtain the same result but without HAVING?

Only using TMP Table I think.

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