Search a record in Multiple Tables

[Ctrl+s]

Is it possible to search for a record in Multiple tables and display the results.

Here is my problem, I have a data base, which contains two tables which contains the User name, City , Phone Number and State.

I want to search for a record, for example, Delhi, so the access query should search the entire records in Two tables and display to me.

Can anyone help me on this one. I am attaching my Sample file.

Drop box link:


https://www.dropbox.com/s/e1ixd7nu6ozp04d/Test.accdb

4shared link:


http://www.4shared.com/file/YLZnCb6L/Test.html

Mediafire link:


http://www.mediafire.com/?djy67tb3i7lamxi


Thank you In advance,

Best Regards,

[Ctrl+s]

Any Help Mates???

[mohanvijay]

Use WHERE clause

[ronald303]

Start Microsoft Access and open up an existing database with which you need help or simply start a new blank database

[BrianMH]

Your looking for a union query. Go into sql view and edit it manually.

IE



select [User name], [City] , [Phone Number] and [State] from table1
where [User name] = "Brian"
union all
select [User name], [City] , [Phone Number] and [State] from table2
where [User name] = "Brian"