My suggestion is to create a "V" type dictionary item(s) that with point to your other file.
For example, if you want to look at the city name in your file, ORDER.FILE.OTHER, create the following: 001: V 002: TRANS('ORDER.FILE.OTHER', @ID, <location of city in ORDER.FILE.OTHER'>, 'X') 003: 004: City (ORDER.FILE.OTHER) 005: 30L 006: S Also, I recommend that you check out the capabilities of TRANS. There are other return codes. Hope this helps. Grant W. Boice, Jr. Systems Administrator Benchmark Electronics, Inc. Manassas Division 8500 Phoenix Drive Manassas, VA 20110 Phone: (703) 334-0156 Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> Web: www.bench.com <http://www.bench.com> -----Original Message----- From: Burwell, Edward [mailto:[EMAIL PROTECTED] Sent: Friday, April 30, 2004 11:05 AM To: 'U2 Users Discussion List' Subject: RE: [UD] Union Query I understand how Unibasic could handle a list that has been merged, but how would you do a Uniquery statement? for example: SELECT ORDER.FILE WITH DATE > "1/1/2004" SAVE-LIST LIST1 SELECT ORDER.FILE.OTHER WITH DATE > "1/1/2004" SAVE-LIST LIST2 GET-LIST LIST1 TO 1 GET-LIST LIST2 TO 2 MERGE.LIST 1 UNION 2 SAVE-LIST LIST.ALL GET-LIST LIST.ALL What do you enter here? LIST ORDER.FILE NAME ADDRESS CITY STATE ZIP or LIST ORDER.FILE.OTHER NAME ADDRESS CITY STATE ZIP How would a virtual dictionary know which file to get the NAME ADDRESS CITY and STATE from? Thanks. Ed Burwell [EMAIL PROTECTED] 973.361.5400 x1512 -----Original Message----- From: Baakkonen, Rodney [mailto:[EMAIL PROTECTED] Sent: Friday, April 30, 2004 10:27 AM To: 'U2 Users Discussion List' Subject: RE: [UD] Union Query You could use MERGER.LIST to get one list which is a UNION of two separate selects of each file. But you would not know which file the key was from when you were done. But Unibasic or Virtual dictionary items could take the merged list and produce what you are looking for. -----Original Message----- From: Burwell, Edward [mailto:[EMAIL PROTECTED] Sent: Friday, April 30, 2004 9:13 AM To: 'U2 Users Discussion List' Subject: [UD] Union Query Hello, Does anyone know of a way to do the equivalent of a UNION "query" (really a LIST or SORT) on 2 or more different UniData files? I have 2 files in separate accounts that are structured the same. I want to do something like: SORT ORDER.FILE AND ORDER.FILE.OTHER WITH DATE > "01/01/2004" NAME ADDRESS CITY STATE ZIP Thanks in advance. Ed Burwell [EMAIL PROTECTED] 973.361.5400 x1512 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users