fredyciang
Member
- Joined
- Dec 28, 2011
- Messages
- 6
- Programming Experience
- 1-3
Ok. i got two table with same structure but different data. columns are ("cust","qty","date"). note that no Primary Key on both table.
what i wanna do is to get new datarow from B that is not in A.
i have tried this code :
dim result = (from source in sourcesB select source) _
.except _
(from dest in destA select dest)
but this doesnt work. duplicated item is happen to be included.
any solution? TQ
what i wanna do is to get new datarow from B that is not in A.
i have tried this code :
dim result = (from source in sourcesB select source) _
.except _
(from dest in destA select dest)
but this doesnt work. duplicated item is happen to be included.
any solution? TQ