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