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

try

...
 WHERE UPPER(V.full_name) IN (SELECT  UPPER(VV.full_name)  FROM i_vendor VV );
....

if UPPER(VV.full_name) is an unique field you can uses INNER JOIN.

EXISTS() is equal to IN () ,
NOT EXISTS() is not equal to NOT IN ()