|
You can save yourself a step by having the second query output to the same file as the first but with the ADD option. With the same caveat that you have the same fields output in both queries. Date: Mon, 20 Jan 2003 11:08:12 -0600 From: "Rubino, Jim" <Jim.Rubino@Fike.com> Subject: RE: Query400 question I agree with Peter........you would need to create two queries. In another posted reply you said that you would need to have these to combined. You could still run two queries, each of the results to an outfile and then copy these to files in one file and run a query or report of this new file. NOTE: YOU WOULD NEED TO BE SURE THAT THE TWO OUTFILES YOU CREATED HAVE THE SAME FIELDS AND SIZES IN ORDER FOR YOU TO COPY THEM INTO ONE FILE. Does this make sense? Jim
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.