View Single Post
  #5  
Old June 6th, 2010, 04:51 PM posted to microsoft.public.access.queries
PieterLinden via AccessMonster.com
external usenet poster
 
Posts: 307
Default Multiple tables search

naveen prasad wrote:
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.


Personally, I think you should redesign. If you have lots of optional fields,
you can put them in a separate table, but I would put a field in the table
that identifies what kind of "person" or whatever this is. Then you can put
all the stuff in one table and use the indexes. If you use a union query,
they all get ignored. When your tables get to over about 100 records,
performance will be terrible.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...eries/201006/1