>Hi,
>I am trying to import customer data to my table. Customer provided me description as data, however my data design is using surrogate key. Therefore I need to do some works.
>
>Customer Master Table - ItemCode, GroupDescr, CateogryDescr
>Expected Table - ItemCode, GroupID, CategoryID
>
>GroupID/Category could be empty. Therefore, I use LEFT JOIN as below.
>
>

SELECT m.*, g.GroupID ;
>FROM MasterTable m LEFT JOIN Groups g ON m.GroupDescr = g.Descr ;
>INTO CURSOR mycursor

>
>Don't know why, after run this SQL, duplicated record exist in new resultset.
>
>Any ideas?
>
>Thank you

Run this and you will find out why:

SELECT *;
FROM MasterTable m;
     LEFT JOIN Groups g ON m.GroupDescr = g.Descr ;
INTO CURSOR mycursor

My guess is that you have more that one Descr matched in Groups table.
Check also SET ANSI in HELP.