Hi Borislav.
I see what you mean. I'll try using this as a source string for SqldataSource.
Thank again for your help.
Regards,
Gerard



>>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.......
>