If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Multiple tables search
Hi all,
Kindly solve my problem. I have a mdb file. tables created t1,t2,t3,t4. fields are almost same in all tables, but the data is different in all tables. fields are.. name, age, mobile_number,place. I want to create a query to get name by mobile_number search. In query execution the input i want to give is mobile number only, it should search the mobile number in all tables and get the correct name. kindly help how can should i create the query. |
Thread Tools | |
Display Modes | |
|
|