>>>>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.
>
>
>
>Test it:
>

>CREATE CURSOR csrVendors (Id I, Full_Name C(20))
>CREATE CURSOR i_vendor (Full_Name C(20))
>
>
>*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 VV.full_name = V.full_name) ;
>INTO CURSOR csrVendorDups NOFILTER
>BROW NORMAL
>
>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   && BOOM :-)
>

>
>And becuase you use EXISTS you can use INNER JOIN instead of LEFT.

Yes, I already found out that you're right - I removed the second part and the query worked (got error further). So, can switch to inner join. I forgot that the purpose was to find dups, hence INNER JOIN :)