Can I call DbDataAdapter.Fill with a DbDataAdapter.SelectCommand that has a inner join to populate DataSet in C#/ADO.NET 2.0

Question

or do I have to use 2 separate DbDataAdapters with single-table Selects and then use DataRelations?

like:

SELECT Persons.LastName, Persons.FirstName, Orders.OrderNo
FROM Persons
INNER JOIN Orders
ON Persons.P_Id=Orders.P_Id
ORDER BY Persons.LastName

I can't yet try this. I'm designing a xml config file schema for a general program so it would help a lot!

-cheers & BR: Matti