TCL (or whatever your flavor calls the queery language) is a single file
oriented language. No joins.  You would need to create TRANS items in the
dictionary of one of the files pointing to the other.  Are the record ID's
in both files the same for a given record that you would want to relate?

-----Original Message-----
From: Burwell, Edward [mailto:[EMAIL PROTECTED]
Sent: Friday, April 30, 2004 8: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

Reply via email to