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.