By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,665 Members | 1,372 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,665 IT Pros & Developers. It's quick & easy.

Combine Tables Then Append

P: 2
I want to combine 3 tables with like data then append it with a filter.

Tables: NewStarts, Complaints, Memos

Combine: Date, Address, Route, Pub, etc....

Then sort: previous 8 days, pub/freq for that day etc...

I can already do the append filter, but I cant combine and then append.
I tried a Union and did the combine.. but lack the part to append the union.

Please help me :)
Nov 20 '06 #1
Share this Question
Share on Google+
2 Replies


NeoPa
Expert Mod 15k+
P: 31,273
To make this easier, do the UNION query and save it.
Now build an APPEND query using the UNION query as its source.

You can also do it with embedded subqueries.
Expand|Select|Wrap|Line Numbers
  1. SELECT subSQL.* FROM (SQL of sub query) AS subSQL
Nov 20 '06 #2

P: 2
I tired that. I get multiple records depending on the total amount of entries in a table. IE: table 1 has 9 lines therefore the appended union results 9 duplicate entries.
Nov 21 '06 #3

Post your reply

Sign in to post your reply or Sign up for a free account.