• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 223
  • Last Modified:

Combining two tables into one in the same database

How do I combine two tables (trans and trans1) that have the same structure into one table named trans using SQL statements? These tables are in the same MS Access database.
TIA
0
TrueBlue
Asked:
TrueBlue
2 Solutions
 
MelMcCommented:
Select *
FROM trans
UNION ALL
Select *
From trans1
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
If you truly want to combine them:

INSERT INTO trans SELECT * FROM trans1

Otherwise, if you just want to "view" them, use the UNION as suggested by MelMc
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now