query help2

[sona]

hia

I have a table

stuid name age sex
1 deepa 23 F
2 indu 22 F
3 Prem 25 M
4 Pri 22 F

Another table
A B
1 2
3 4

i need an output as following

1 deepa 2 indu
3 prem 4 pri

[ales]

Hi.

select the_table1.stuid, the_table1.name, the_table2.stuid, the_table2.name
  from the_table the_table1, the_table the_table2, another_table
 where the_table1.stuid = another_table.A
   and the_table2.stuid = another_table.B