I am trying to join a FoxPro table with an SQL table. I can get both tables into the same dataset, now I want to create some views (I guess) that join these tables so I can bind the view to a datagrid. The I was hoping to build a view as a select against both tables and not not use relation objects since the join scenerio is dynamic.

DataSet ds = new DataSet();
ds.Tables.Add(DataClass.GetFoxTable("select * from books"));
ds.Tables.Add(DataClass.GetSqlTable("select * from bookprices"));

The problem is that I cannot find where I can run a select statement against my dataset...

Please help!