Use the UNION keyword in MERGE.LIST. GET.LIST LIST 1 TO 1 GET.LIST LIST2 TO 2 MERGE.LIST 1 UNION 2
If you are using UniData, use ECLTYPE U not ECLTYPE P. get.list LIST1 TO 1 get.list LIST2 TO 2 merge.list 1 UNION 2 >From HELP: Note: UniQuery only supports MERGE.LIST is in ECLTYPE U. Note: The INTERSECTION and UNION operators build a list of unique items. If an item exists in list1 and list2, it is saved only once Shaun Ferguson Information Technology, Application Architect I Ferguson Enterprises, Inc. 12500 Jefferson Avenue * Newport News * VA * 23602-4314 T: +1 (757) 989 2916 * F: +1 (757) 989 2801 www.ferguson.com <http://www.wolseley.com/> _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users