H
hawornk via AccessMonster.com
Here is the SQL from my Union Query (yes, I know the names for some of the
fields aren't the greatest, but they are what they are, and that's not part
of my question).
How do I turn this into an append query?
SELECT[hc query].[include?],[hc query].[question],[hc query].[consumer answer]
,[hc query].[consumer author],[hc query].[consumer answer date],[hc query].
[hcp answer],[hc query].[hcp author],[hc query].[hcp answer date],[hc query].
[View consumer],[hc query].[view HCP],[hc query].[expr1],[hc query].[expr2],
[hc query].[expr3],[hc query].[expr4],[hc query].[expr5],[hc query].
[citation1],[hc query].[citation2],[hc query].[citation3],[hc query].
[citation4],[hc query].[citation5],[hc query].[citation6],[hc query].
[citation7],[hc query].[citation8]
from [hc query]
UNION ALL SELECT [infant query].[include?], [infant query].[question],
[infant query].[consumer answer], [infant query].[consumer author], [infant
query].[consumer answer date], [infant query].[hcp answer], [infant query].
[hcp author], [infant query].[hcp answer date], [Infant query].[View consumer]
, [Infant query].[view HCP], [infant query].[expr1], [infant query].[expr2],
[infant query].[expr3],[infant query].[expr4],[infant query].[expr5],[infant
query].[citation1],[infant query].[citation2],[infant query].[citation3],
[infant query].[citation4],[infant query].[citation5],[infant query].
[citation6],[infant query].[citation7],[infant query].[citation8]
from [infant query];
fields aren't the greatest, but they are what they are, and that's not part
of my question).
How do I turn this into an append query?
SELECT[hc query].[include?],[hc query].[question],[hc query].[consumer answer]
,[hc query].[consumer author],[hc query].[consumer answer date],[hc query].
[hcp answer],[hc query].[hcp author],[hc query].[hcp answer date],[hc query].
[View consumer],[hc query].[view HCP],[hc query].[expr1],[hc query].[expr2],
[hc query].[expr3],[hc query].[expr4],[hc query].[expr5],[hc query].
[citation1],[hc query].[citation2],[hc query].[citation3],[hc query].
[citation4],[hc query].[citation5],[hc query].[citation6],[hc query].
[citation7],[hc query].[citation8]
from [hc query]
UNION ALL SELECT [infant query].[include?], [infant query].[question],
[infant query].[consumer answer], [infant query].[consumer author], [infant
query].[consumer answer date], [infant query].[hcp answer], [infant query].
[hcp author], [infant query].[hcp answer date], [Infant query].[View consumer]
, [Infant query].[view HCP], [infant query].[expr1], [infant query].[expr2],
[infant query].[expr3],[infant query].[expr4],[infant query].[expr5],[infant
query].[citation1],[infant query].[citation2],[infant query].[citation3],
[infant query].[citation4],[infant query].[citation5],[infant query].
[citation6],[infant query].[citation7],[infant query].[citation8]
from [infant query];