View Single Post
  #1  
Old June 6th, 2010, 10:33 AM posted to microsoft.public.access.queries
naveen prasad[_2_]
external usenet poster
 
Posts: 80
Default 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.