I have 2 datatables. SVTaskDataDT and VCFiltered DT.
SVTaskDataDT has the following data:
PunchCodeSV VendorTotalSV
2510 100
3000 0
VCFilteredDT has the following data:
VENDORID TASK_CODE_FK RATE
DNBGR2 2510 100
DNBGR2 2501 100
DNBGR2 9901 18.75
I am trying to compare these two datatables in the following manner. But I am not getting any common rows which I should be. Could anyone provide insight as to what I may be missing here.
Can you check ColumnType of PunchCodeSV and TASK_CODE_FK?
I think one of them is Int and the other one is String. Then, when try to join they are considered different values (for example, 2510 is not equal to “2510”) and you don’t get any common row.
I cannot tell you how appreciative I am. This worked and i am able to find the common rows. you are right. the data was not matching due to different datatypes of the columns. I didnt have to use the query anymore. Just the inner join worked.