If I create a DataSet with a command like:

DataSet dsOrders = this.GetDataSet("SELECT * FROM orders WHERE conditions")

Is it possible to then run a second SQL against the resulting DataSet? I can accomplish this in SQL Server with the following:

CREATE VIEW dsOrders AS
SELECT field1, field2 FROM myTable WHERE conditions

SELECT field1, field2 FROM dsOrders WHERE moreconditions

I have a complex query that returns a DataSet that I would then like to run several other queries against. Thanks in advance for any suggestions.

Kind Regards,

Mat