maximyshka
asked on
Modify query
How can I modify query to make table from union query.
I should use only 1 query (I know how to do it in 2 queries, I need to do it in 1 query)
SELECT [Insurance Payees].*
FROM [Insurance Payees]
UNION SELECT [Tax Payees].*
FROM [Tax Payees];
I should use only 1 query (I know how to do it in 2 queries, I need to do it in 1 query)
SELECT [Insurance Payees].*
FROM [Insurance Payees]
UNION SELECT [Tax Payees].*
FROM [Tax Payees];
ASKER
That I know myself. So Answer is not possible?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
That does seem to work, technically not a UNION query by itself. But it is one query.
mx
mx
It is a make table query based on a union query - done in one statement and saved as one Query object in Access - which answers the question asked.
It is a make table query based on a union query - done in one statement and saved as one Query object in Access - which answers the question asked.
I see that ... and it's a cool solution.
mx
mx
It is a make table query based on a union query - done in one statement and saved as one Query object in Access - which answers the question asked.
apologies for the annoying-multiple posts... made update from phone and it posted several times
:-(
won't do that again...
:-(
won't do that again...
mx