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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

append

Status
Not open for further replies.
wdu94

wdu94

Programmer
Aug 15, 2001
61
0
0
US
Hello,

I have 2 tables that have the same field name in these 2 table. I want to append the same field in one table.

Thanks for your help.
Jeannia

 
Sort by date Sort by votes
you can query the two tables seperately and then use a UNION command to merge the results

eg.

SELECT c1 FROM Table1
UNION
SELECT c1 FROM Table2

there are several options for the UNION command which can be found in the SQLServer Books Online
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

damipera
  • Locked
  • Question
Append number 2
Replies
3
Views
20
damipera
damipera
misscrf
  • Locked
  • Question
Triggers and Inserts from Access Append Query?
Replies
2
Views
43
misscrf
misscrf
RosieGp
  • Locked
  • Question
Insert and update/append to existing data.
Replies
5
Views
10
philhege
philhege
katrina11
  • Locked
  • Question
How to append four tables? 1
Replies
2
Views
17
drlex
drlex
DaveBenson
  • Locked
  • Question
SQL Database backup - append, overwrite or new file?
Replies
7
Views
30
DaveBenson
DaveBenson

Part and Inventory Search

Sponsor

Back
Top