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