Information générale
Catégorie:
Code, syntaxe and commandes
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement