RE: What's an exceptin join?

["Dennis Lovelady" <iseries@xxxxxxxxxxxx>]

Oops.  I meant:

Dennis Lovelady
http://www.linkedin.com/in/dennislovelady
--
"I don't want to achieve immortality through my work, I want to achieve it
through not dying."
        -- Woody Allen 
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-
> bounces@xxxxxxxxxxxx] On Behalf Of Dennis Lovelady
> Sent: Wednesday, October 14, 2009 11:08 AM
> To: 'Midrange Systems Technical Discussion'
> Subject: RE: What's an exceptin join?
>
> > In an interactive SQL session I typed
> >
> > select * from file1 exceptin join file2 on etc......
> >
> > Would you have thought that the request would run? You can put almost
> > anything inplace of the word exception. As for the results returned,
> I
> > haven't checked.
>
> Yes, the statement is fine.  It's giving an internal name to the table.
> For
> example, you could have done
>    "select exceptin.column1, exceptin.column2 from file1
>       [exception] join file2 on..."
>
> Dennis Lovelady
> http://www.linkedin.com/in/dennislovelady
> --
> "The most difficult thing in the world is to know how to do a thing and
> to
> watch someone else doing it wrong, without commenting."
>         -- T.H. White
>
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.