How to track down doubloons in valentina ?

[Ruslan Zasukhin]

On 9/30/04 12:59 PM, "Beatrix Willius" <beatrix.willius at de.opel.com> wrote:

> Please find below a quick example from Access:
> 
> SELECT [PART_NUMBER], [Gross Value], [Phase Name]
> FROM [epsilon vpps]
> WHERE [PART_NUMBER] In (SELECT [PART_NUMBER] FROM [epsilon vpps] As Tmp
> GROUP BY [PART_NUMBER] HAVING Count(*)>1 )
> ORDER BY [PART_NUMBER];
> 
> This query searches for duplicates in the Part_Number field and also shows
> Gross Value and Phase Name. If I want to search for duplicates in
> something like First Name + Last Name, I would create a query with the
> concatenated fields in it and base the duplicate search on this query.
> 
> Cannot check now, if this works in Valentina.

Nom because of HAVING,

And even this is not the same what Oliver want.

He want LIKE for comparisons.


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