If I have 2 tables in a DataSet and create a DataRelation between them, what kind of Join is that? What I am looking to do is perform a SQL INNER JOIN between two DataTables, and end up with 1 DataTable in my DataSet. How can I do this?

Hey, Mike,

When you establish an ADO.NET DataRelation object, you have the ability to easily get all the child rows for a particular parent row (or get the parent row for a specific child row).

If you're using typed datasets, ADO.NET automatically creates a method for the strongly typed row of the parent table, so that you can read the corresponding children table. By default, the name of the method will be GetChildTableNameRows().

If you have a relation established, you can specify Parent(ColumnName) and Child(ColumnName) syntax in a RowFilter or DataTable.Select(), to reference columns from both tables.

If this doesn't help....if you can post the structure for your tables and what specifically you're looking to do, we can go from there.

Kevin