In .Net v1.1 I have a few datasets which I would like to combine. They
are all in the same format such as a date, int and double fields and
they need to output to another dataset that is
date, int from dataset1, double from dataset1,int from dataset2, double
from dataset2 matching values on the date value.
What is the best method of achieving this?