If you have two tables in a DataSet and need to do a SELECT with a JOIN
between the two tables (or RIGHT OUTER JOIN in my case), how do you do that
if the data was read in from an XML file using DataSet1.ReadXML ?

Isn't the DataTable SELECT only for working with one table?  And also, if
you use an sqlDataAdapter and an sqlCommand object to do it, doesn't that
require that you be connected to a database?  From what I'm seeing, the
DataView also only works with one table.

I need to obtain the results of the following SELECT between two tables in a
dataset:

SELECT c.Name, c.Path, f.Path
FROM CTable c RIGHT OUTER JOIN FTable f ON c.Name = f.Name
WITH f.Path <> c.Path

but how can this be done without a connection to a database?  Thanks.