Hi

Is there a way in a web form to set a data source to a select of a select
Nornally, a Select Query of a SqlDataSource might look like:
Select * from Customers where Cus_Area = "USA"
I then want to be able to narrow this down further by using another select, but without using a single complicated Join, as I find in certain circumastances the string becomes unwieldy, the join can get complicated or performance is not optimum.

Ideally I would like the resulting source to be the result of a no. of selects as in:
Select * from Customers Join Stocks on X=Y where Cus_Area = "USA" into Cur1
Select * from Cur1 Join Sales on A= B where Sal_Val > 1000 into Cur2
Select * from Cur2 Join Groups on F=G where Grp_type = "ABC"
etc

Is there a way to set up the Select query of a SqlDataSource like this

Regards,
Gerard