search from another table ..

rohit00082002

Hi,

I have 2 tables in a page, say oTable1, oTable2.
oTable1 has say 5 columns 1) index no. , 2)name, 3) phone number, 4) address
oTable2 has 2 columns 1) index no., 2) name.
This name column is just same as oTable1. Both table essentially represent same database data.

Now I need to search in oTable2 for any data which is present in oTable1, and result to be filtered in oTable2. How can this be achieved?
-----------------------------------
oTable1
index ..............name................phone.............address
---------------------------------------------
1.......................Name.........12345456........myaddress
2.......................Name2.........989898........myaddress2


**************************************************************************************

oTable2
index ..............name
-------------------
1.......................Name
2.......................Name2


So if I search 12345 in oTable2 it should show row-1.

Thanks

rohit00082002

Any one may help ?