May I ask if it is possible to join two datatable with different number of rows?
The truth is, I have 3 datatables which share one common column.
Table 1 is the main column, for example holds the below data:
Then there is Table 2 which holds information for A and C
There is also Table 3 which holds information for B
As you can see Table 2 and 3 will bring in new columns to Table 1. None of their new columns will be the same as each other, so does the rows (if table 2 holds information for A, A won’t appear in B)
The reason I want to join these tables together is mainly cause I needed the column “Age” from Table 1. If there’re better ways to do this, please advise.
Thank you very much.