>Hi Borislav. Thanks for your reply.
>How do you set the slect string in SqlDataSource to come from 2 separate select commands ?
>
>Regsrds,
>Gerard
>
>
:-)
I didn't set anything to SqlDataSource but I can write a SELECT statements. If yo want to get a SubSet from a recordset you just could write the first query in FROM clause as derived table:
SELECT .....
FROM (SELECT .... FROM ..... WHERE .....) Tbl1
WHERE Tbl1.......
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.