Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
waltersmx2
Starting Member
4 Posts |
 Posted - 2004-05-26 : 13:03:30
|
| Can you combine tables or queries in Access?If I have two queries that have the same field names in both tables. I need to add the results from the second query to the first query to create a new table or query. I do not want to have separate columns for the fields in the new query. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-05-26 : 13:04:41
|
| Does Access have UNION:SELECT Column1FROM Table1UNIONSELECT Column1FROM Table2Tara |
 |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2004-05-26 : 15:17:30
|
| yes, it does ... UNION is the way to go .. but you must write out the SQL manually, there is no wizard or "design" view for unions, only straight SQL.- Jeff |
|
|
|
waltersmx2
Starting Member
4 Posts |
Posted - 2004-05-26 : 16:57:29
|
| Thank you, it worked! |
|
|
|
|
|
|
Combining or merging tables