i wonder how i can query 2 diffrent tables with int <script > </script > in asp.(for example two select statments for 2 diffrent tables. I be happy if some one help me here. thanks

Like this?
strSQL1 = "SELECT * FROM table1"

strSQL2 = "SELECT * FROM table2"

let me tell u bit details of above queries. execute 2 quries using 2 different record set.
strSQL1 = "SELECT emp_no, e_name from table1"
strSQL2 = "SELECT dept_no, d_name from table2"
set rs_table1 = con.execute(strSQL1)
set rs_table2 = conn.execute(strSQL2)
'now you can display the output of both queries by calling their record set. like
response.write rs_table1(0)
response.write rs_table2(0)
response.write rs_table1(1)
response.write rs_table2(1)
' these r index number of those record sets. u also can call values by using column name
response.write rs_table1(emp_no)
response.write rs_table2(dept_no)
response.write rs_table1(e_name)
response.write rs_table2(d_name)
i hope u can find some help from this example.
Zee

dear u can even fill these tables in a sigle dataset and retrieve them

SqlDataAdapter da = new SqlDataAdapter();
DataSEt= new DataSet()

da.SelectCommand=str1;
da.Fill(ds);
da.SelectCommand=str2;
da.Fill(ds);

//now u can retrieve
ds.Tables[0]................
ds.Tables[1]......................

Thank u for u reply. how i can do the same for dirrent value passed to this page. What i mean for each diffrent value passed to this page it runs similer block of code but for diffrent tables. I mean kind of if statments. I be happy if u show me some code. thanks

if rs_table1(emp_no) = 1 then
   e_no = "one"
elseif rs_table1(emp_no) = 2 then
   e_no = "two"
else
   e_no = "none"
end if
response.write e_no

i hope this is the answer of ur question.

Zee