All Forums Tools
u156531 6 posts Joined 10/14
06 Oct 2014
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

dnoeth 4628 posts Joined 11/04
06 Oct 2014

This should work, what's the error message?

Dieter

You must sign in to leave a comment.