Datatable - can we join data

[Krish]

I have 2 tables each having a date in column1 and value in column 2.
I would like to extract out the common date entries from the 2 tables.
Ideally I would do a join in SQL, how do I do something like that in
datatables/dataviews etc.

regards

[Uri Dor]

http://support.microsoft.com/default...b;EN-US;326080

Krish wrote:

I have 2 tables each having a date in column1 and value in column 2.
I would like to extract out the common date entries from the 2 tables.
Ideally I would do a join in SQL, how do I do something like that in
datatables/dataviews etc.

regards

[kh]

> I have 2 tables each having a date in column1 and value in column 2.

I would like to extract out the common date entries from the 2 tables.
Ideally I would do a join in SQL, how do I do something like that in
datatables/dataviews etc.

No, you cannot join tables like you can in SQL. You will either have to get the required data from each table seperately, or you can create a DataRelation between the tables on the date columns, find the date you need in the parent table, and then call DataRow.GetChildRows.

hth

kh