Dats Set Relationships

[Zorpiedoman]

I'm experimenting with DatsSets, and I'm wondering if the follwing is
possible, and if so, how:

Dataset has 2 tables:

Customers
-----------
ID (int identity)
CustomerName (char(50)

Locations
----------
ID (int identity)
CustomerID (int)
LocationName (char(50))

I have created a Relation between Customers.ID and Locations.Custo merID, and
appended it to the DataSet.Relatio ns collection.

Is there an easy way to extract a DataTable that would return the same
results as the following SQL statemnet without actually running back to the
database or assembling it row by row?

Select CustomerName, LocationName From Customers Inner Join Locations on
Customers.ID = Locations.Custo merID

Thanks in advance...


--
--Zorpie