I really don't know what you really looking for Sukuti..but I am assuming that you want something like this: (asp display) Execute SQL1 Set it to RecordSet --- RS1 Similarly, Execute SQL2 Set it to RecordSet -- RS2 Now, Loop RS1 to display...something like With Response .write "" While RS1.EOF = False .write "" RS1.MoveNext ' move forward Wend ' Now repeat the same process for RS2 While RS2.EOF = False .write "" RS2.MoveNext ' move forward Wend ' finally close table .write "

" & RS1("Value") & "

" & RS2("Value") & "

" End With OR..... You can join those two tables and create a view....and treat it like a single talbe.... I hope it helped a little...