There is no binding between different tables  via DataSet object for viewing purposes. You can only filter and sort them via DataViews and regarding to parent table's data.
I would also like to have DataSet capability like SQL Query to join tables and get out exactly what I want, which would BTW be also VERY VERY fast, while all data  resides in-memory. Like DataSet Query. No Procedures or any of the other other SQL capabilities, but only pure SELECTING, DELETING, INSERTING, UPDATING and DROPING.