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
I am not the most powerful man in this world.
I am not the worst man in this world either.
I just as same as all of you.
I still need to learn from my mistakes...