RE: [U2] Union Query

[Phil Walker]

There are three ways to accomplish this as far as I can tell:   SQL UNION query which requires nothing else to be done. You do not need to use the MERGE.LIST or equivalent with this as a SQL and the UNION operator allow multiple files to drive the query. However in the case of the UNION operator the result sets from the 2 or more queries need to have the same number of columns and the columns need to be the same data types etc. Use the MERGE.LIST command to merge the two lists. However you still have a problem, as you need a file to run the LIST or SELECT through which has ALL the IDS from both – or more - files in it as the U2 LIST and SELECT commands only use 1 file to drive the query. You can only do lookups to other files. Write a BASIC program that does what you want.   I would suggest to subscribers of this list that they embrace the SQL capability in U2 and use it where appropriate. I hope that this is through lack of knowledge of the capabilities rather than a bigotry of ours is better than yours as exhibited by a unnamed poster in the list over the last few months.   Just needed to get that off my chest ;-)     Phil Walker +64 21 336294 [EMAIL PROTECTED] infocusp limited \\ PO Box 77032, Auckland New Zealand \ www.infocusp.co.nz DISCLAIMER:  This electronic message together with any attachments is confidential.  If you are not the intended recipient, do not copy, disclose or use the contents in any way. Please also advise us by return e-mail that you have received the message and then please destroy. infocusp limited is not responsible for any changes made to this message and / or any attachments after sending by infocusp limited. We use virus scanning software but exclude all liability for viruses or anything similar in this email or any attachment