Re: 1st RPG program with embedded SQL

This chart is nice for most databases. Just realize that, while the second
row (not the inner join) works on DB2, we can also use a left|right
exception join instead of testing for null.

On Tue, Aug 20, 2019 at 9:24 AM Joe Pluta <joepluta@xxxxxxxxxxxxxxxxx>
wrote:

Thanks, Doug, I like that red and white one.

Here's the URL directly to it. Very nice.

https://www.reddit.com/r/webdev/comments/b46iyd/sql_joins/


On 8/20/2019 8:17 AM, Doug Davie wrote:

I keep a visual representation of SQL joins on my wall.

Not sure on copyrights, so rather than post a specific URL or image, just
use google image search and search for: sql joins

The copy I keep on my wall is the first and second that came up in my
search (it is red and white in color).

There are a few others that show as well, so find one that makes sense to
you and print a copy to hang

--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com