Gordon J. Glorfield wrote: > In that case, I'm sorry to say, there is no way to logically > do what you're asking with UD.
Gordon, you should now better! ;^) sql> SELECT NAME ADDRESS CITY STATE ZIP FROM ORDER_FILE UNION SELECT NAME ADDRESS CITY STATE ZIP FROM ORDER_FILE_OTHER; All you need here Ed is a VOC pointer to each file that is SQL compatible - ie no "." dots etc. There is no need to build a schema or set up ODBC or do anything complicated in UniData just to query a file with SQL from the command line. Cheers, Ken >> -----Original Message----- >> From: Burwell, Edward [mailto:[EMAIL PROTECTED] >> 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? -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users