That was my first try, but the NSELECT only checks PEOPLE for those that are in 
the list returned by the first
That are not in PEOPLE, it doesn't check for those in PEOPLE that are not in 
the list returned.

George

-----Original Message-----
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R.
Sent: Wednesday, October 17, 2012 10:05 AM
To: 'U2 Users List'
Subject: Re: [U2] Selection Suggestions for using UV instead of SQL

Do it in more than one command?
SELECT REGISTRATION WITH EID = '1' SAVING UNIQUE PID
NSELECT PEOPLE

Or am I missing something?


John

-----Original Message-----
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Wednesday, October 17, 2012 9:59 AM
To: U2 Users
Subject: [U2] Selection Suggestions for using UV instead of SQL

Ok.

I have file1 - "people" that has @ID of PID I have file2 - "registration" that 
has @ID of PID+EID+RID  (EID = event id,  RID = registration id)

I want to select people who are not in the registration file with an EID of "1".

With an SQL statement - I could join the two, then do the select or use a 
subquery (I'm on UV 10.0.2 - not sure if sub querys work) Just curious how this 
could be done with UV Native, and without involving a program.

I first tried "SELECT REGISTRATION WITH EID = '1' SAVING UNIQUE PID" -> 
"NSELECT PEOPLE"

But that returned 0 - since the NSELECT only works off the current select list, 
not the whole file

Yes, I could create a temporary file, then select off that Yes, I could read 
each people record, then loop through registration to see if it doesn't exist.
Both of the above require programming
I guess I could create a subroutine that does the looping through registration, 
and put that into an I descriptor - looking for another option.

George

_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Reply via email to