Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Simple Query Question

Status
Not open for further replies.
vicktown

vicktown

Technical User
Jul 13, 2004
27
CA
If i have 2 tables, both of which contain a list of titles, is there a way to create a query to list all titles from both tables in one field?
 
Sort by date Sort by votes
Take a look at UNION query.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

BJZeak
  • Locked
  • Question
Struggling with finding an answer to a simple question
Replies
5
Views
713
BJZeak
BJZeak
TrekBiker
  • Locked
  • Question
Running query with parameter from Inputbox 2
Replies
8
Views
803
TrekBiker
TrekBiker
TrekBiker
  • Locked
  • Question
Use Crosstab query in subform
Replies
9
Views
727
dhookom
dhookom
TinaS
  • Locked
  • Question
Quick one I think - question about Properties window in Form Design view
Replies
1
Views
347
dhookom
dhookom
TrekBiker
  • Locked
  • Question
This is the source query for what 1
Replies
12
Views
614
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top