i wish to know how to use two sql commands in .net program

Question

hi,
    i am using 1 sql command for selecting the values from one table,and another cmd for uing the where condition in another table,is it possible.
 
Thank u,