Using the Append statement to write the results from 2 queries to one txt file.

Tools
Enthusiast

Using the Append statement to write the results from 2 queries to one txt file.

Hello,  I need to write/export the results from two or more queries into a txt file. The I'm attempting to accomplish this using the Append statement. So I'm appending two queries to execute after one another. When I submit the queries through the Execute button the first query runs and produces output however the second query never starts and I get an query failed error message. The queries have different columns so I can't use a union statement. Does anyone know how to append the results of two queries into one output file? 

Thanks

1 REPLY
Senior Apprentice

Re: Using the Append statement to write the results from 2 queries to one txt file.

This should work, what's the error message?