>>Hi everybody,
>>
>>I'm getting the title's error on this SQL
>>
>>

>>SELECT V.*,1 as DupType FROM csrVendors V ;
>>INNER JOIN (select MIN(ID) as MinID, UPPER(full_name) as Full_Name FROM csrVendors GROUP BY 2 HAVING COUNT(*) > 1) Dups ;
>>ON UPPER(V.full_name) = Dups.full_name AND V.ID > Dups.MinID ;
>>UNION ;
>>SELECT V.*, 2 as DupType FROM csrVendors V WHERE exists (SELECT full_name FROM i_vendor VV ;
>>WHERE UPPER(VV.full_name) = UPPER(V.full_name)) ;
>>INTO CURSOR csrVendorDups NOFILTER

>>
>>Do you see what may be wrong here?
>>
>>Thanks in advance.
>
>This is the culprit:
>

>SELECT V.*, 2 as DupType;
>       FROM csrVendors V;
>WHERE EXISTS (SELECT full_name;
>                     FROM i_vendor VV ;
>              WHERE UPPER(VV.full_name) = UPPER(V.full_name)) ;
>INTO CURSOR csrVendorDups NOFILTER
>

>
>Change it to:
>

>SELECT V.*, 2 as DupType;
>       FROM csrVendors V;
>WHERE EXISTS (SELECT full_name;
>                     FROM i_vendor VV ;
>              WHERE VV.full_name = V.full_name) ;
>INTO CURSOR csrVendorDups NOFILTER
>

>if you can.

Hmm, are you sure? I really want to test based on the upper function as I don't know the case used in advance. I guess I can switch to LEFT JOIN then.