<p>I have a dataset that contains 2 datatables they link together using a DataRelation.</p>

<p>it it possible to select from those tables into into one result set? </p>

<p>thanks,
Ofer</p>

You can create JOIN tables with the VS DataSet editor, whcih combine your results - you can then write Select queries against that and call them from within your app.
To do it, simply create a new TableAdapter, then add BOTH tables into the editor (use the visual one), and select the fields you want to use from both tables, then write the relevant select functions.