Select question:
Assume that I have 2 files, such as customer and invoice
File1: has 1 attribute, ID
File2: has 2 attributes, ID and FILE1_ID
I have a savedlist with ID numbers from file1.
I want to select all records in file2 which have FILE1_ID matching the
savedlist I already have.
Is
Great! That is exactly what I needed.
I forgot about the INTERSECTION option.
Noah
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jim Bullock
Sent: Monday, July 25, 2005 8:18 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] [UD] Select
Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jim Bullock
Sent: Monday, July 25, 2005 10:18 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] [UD] Select on an attribute
(If BLORP is your savedlist from File1)
GET.LIST BLORP TO 1
SELECT FILE2 SAVING
Noah,
Not directly, but *if* File2 is indexed by its FILE1_ID attribute there
are a couple ways.
Assume that I have 2 files, such as customer and invoice
File1: has 1 attribute, ID
File2: has 2 attributes, ID and FILE1_ID
I have a savedlist with ID numbers from file1.
I want to select
: Monday, July 25, 2005 12:47 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] [UD] Select on an attribute
Sharyl,
That works great if I want all the matches. My specific problem (which
I was not clear on before) is that I will only have a small number of ID
in my save list.
For example:
SELECT
, unless you make it a name that you always
use
when you save the list.
George
-Original Message-
From: George Gallen
Sent: Monday, July 25, 2005 1:38 PM
To: 'u2-users@listserver.u2ug.org'
Subject: RE: [U2] [UD] Select on an attribute
My thought on this would be to do the following:
1
I thought you wanted a list of File2 IDs.
Won't the MERGE.LIST INTERSECTION give you a list of File1 IDs?
Great! That is exactly what I needed.
I forgot about the INTERSECTION option.
Noah
-Original Message-
(If BLORP is your savedlist from File1) GET.LIST BLORP TO 1 SELECT
, 2005 9:07 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] [UD] Select on an attribute
I could write a subr to fetch these, but I don't know how to do it with
uniquery only. I think Noah is saying that he wants to...
SELECT all File2 items if FILE1_ID can be found in the savedlist
containing
Yes, see followup message
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Stevenson,
Charles
Sent: Monday, July 25, 2005 9:41 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] [UD] Select on an attribute
I thought you wanted a list of File2 IDs