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

[Charles Wilt <charles.wilt@xxxxxxxxx>]

WAF....(working as fixed) ;)

You've only asked for c.*

But the join columns aren't seen as part of C or D anymore...

This would fail
select c.su_ID1 from Test4Dupes JOIN Charges c
   using (su_ID1, su_ID2, su_ID3, su_DoS);

You'll have to add the using columns explicity

select su_ID1, su_ID2, su_ID3, su_DoS, c.*
from Test4Dupes JOIN Charges c
   using (su_ID1, su_ID2, su_ID3, su_DoS);

Charles

On Thu, May 10, 2018 at 2:30 PM, Dan <dan27649@xxxxxxxxx> wrote:

> Going a little crazy here.  Running the following query, all of the columns
> from Charges are shown EXCEPT for columns in the USING clause.  Is this
> expected behavior?
>
> select c.* from Test4Dupes JOIN Charges c
>    using (su_ID1, su_ID2, su_ID3, su_DoS);
>
> FWIW, v7r1 with somewhat recent PTF groups applied.  Also, same behavior in
> STRSQL and ACS Run SQL Scripts.
>
> - Dan
> --
> 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