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 strongm 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.
dashusa

dashusa

Programmer
Mar 27, 2006
46
US
hello,
I have a database with four tables:two are orders and two are vendor names. I want to merge the Vendor names so i can reduce it to just three tables and not have duplicate data i think i should use the append query but not sure how to do this..
Thanks in advance
D
 
Sort by date Sort by votes

INSERT INTO NEWVENDOR (SELECT * FROM VENDOR1 UNION SELECT * FROM VENDOR2)
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Moss100
  • Locked
  • Question
Append query dropping leading zero 2
Replies
4
Views
859
Andrzejek
Andrzejek
monkeysee
  • Locked
  • Question
Select Query for append query 1
Replies
12
Views
554
monkeysee
monkeysee
billheath
  • Locked
  • Question
Filters for append query and resultant form
Replies
4
Views
114
dhookom
dhookom
integritycare
  • Locked
  • Question
Append Query
Replies
6
Views
96
integritycare
integritycare
mekohler
  • Locked
  • Question
Append Query Triggered by New Record 1
Replies
4
Views
102
lameid
lameid

Part and Inventory Search

Sponsor

Back
Top