Re: [U2] Left Outer Join Question

In order to simulate select lists in SQL , I create a temporary table, and write the keys I'm 
Looking for as col1

INSERT into temporarytable col1 (SELECT key from file1 where .....)   ** My equvilent to SaveList

Now assuming file2 has similar keys your working with as in file1

Now you SELECT file2 where .... and key NOT IN (SELECT col1 FROM temporarytable)   ** My equivalent to ReadList and Select (or NSELECT in this case)

George



-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Dave Davis
Sent: Monday, March 03, 2014 1:00 PM
To: U2 Users List
Subject: Re: [U2] Left Outer Join Question

This isn't SQL, but uniquery has "NSELECT" that does this.



-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of randyleesmith
Sent: Monday, March 03, 2014 12:44 PM
To: [email protected]
Subject: [U2] Left Outer Join Question

I have 2 files.

File 2 is a black list of records (keys) I want to exclude in and active select list of File 1.

I've been looking into this for a little while and am not sure what I'm doing wrong.

Docs are not very helpful with any examples on the how to do with this.


I know of ways to deal with this in code, but was hoping for an SQL way to deal with it.







-----
I used to be an Optimist until I knocked over the glass.
--
View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/Left-Outer-Join-Question-tp42740.html
Sent from the U2 - Users mailing list archive at Nabble.com.
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
________________________________


Dave Davis
Team Lead, Research & Development

P: 614-875-4910 x108
F: 614-875-4088
E: [email protected]
        [http://www.harriscomputer.com/images/signatures/HarrisSchools.jpg]

[http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]<http://www.harriscomputer.com/>
        6110 Enterprise Parkway
Grove City, OH
43123
www.harris-schoolsolutions.com<http://www.harris-schoolsolutions.com>

This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message.

_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users