Re: Columns in USING clause for join don't appear in SELECT *?

A few...not as many as I'd like...

Besides the problem posed by legacy RPG standards of specifing a different
prefix for the same field in different files...

The using clause on Db2 for i only supports a single join.

Meaning the following is not supported...

select *
from tbl1
join tbl2 using (fld1, fld2)
join tbl3 using (fld1, fld2)

It should be IMHO..

Perhaps requiring parenthesis to explicitly specify a join order...
select *
from (tbl1
join tbl2 using (fld1, fld2))
join tbl3 using (fld1, fld2)

Charles



On Fri, May 11, 2018 at 9:21 AM, Dan <dan27649@xxxxxxxxx> wrote:

Sorry, I meant Charles!

- Dan

On Fri, May 11, 2018 at 11:20 AM, Dan <dan27649@xxxxxxxxx> wrote:

Thanks for that, John! I can only guess that I've not done many queries
that fall in this category.

--
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: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD