I have 2 datatables - dt1 and dt2. there is one column common between dt1 and dt2. I need to use this common column and extract values from dt2 into dt1. No rows should be brought over from dt2 to dt1 if there is no match. All dt1 rows must be present
I am using a left join and it is not going as i want it to.
Anyone has any ideas as to what I am doing wrong?