Hey ya'll, I could really use some help.

I'm working with a very poorly designed database (out of my control to change or alter, I can only query it), and as a result I have two datasets (each from a different database query) that I need to combine based on 3 similar fields. The database will not run the query I need that would join the 3 tables together so I am attempting to work around that.

I have datasetA from which I created datatableA that has the following columns: reportnumber, corenumber, subsample, size, name

datasetB from which I created datatableB that has the following columns: reportnumber, corenumber, subsample, depth, density, velocity, susceptibiliy, impedence

Is there anyway I can combine the two datatables into one datagridview? Thanks for any and all help!