Albert:
Thanks.
For reasons obscure, the LEFT OUTER JOIN gave me the left, but not the
right table columns. For another day.
An INNER JOIN did the trick.
CREATE TEMP VIEW GreatFall_tvw AS +
SELECT [t1.All Columns] +
[t2.All but the one right-side matching column] +
FROM Humpty_vw t1 INNER +
JOIN Dumpty_vw t2 +
ON t1.VerseID = T2.VerseID
Too bad there's not an 'ALL EXCEPT [columnname]' syntax.
Bruce
------ Original Message ------
Sent: 4/6/2016 12:52:45 PM
Subject: Re: [RBASE-L] - JOIN: 2nd Matching Column
From: "Albert" <[email protected]>
To: [email protected]
Cc:
Create view whatever as SELECT <column list> FROM ..... LEFT OUTER JOIN
.... ON ...
On 2016-04-06 12:48 PM, Bruce Chitiea wrote:
All:
My joins work, whether or not I rename the "right-side" matching column
in the second tableview. No problem.
But every join result includes both matching columns. That redundant
column can be dropped later, but ...
Is there a way to suppress inclusion of that "right-side" matching
column in the join result itself ?
Thanks
Bruce Chitiea
SafeSectors, Inc.
909.238.9012 mobile
--
You received this message because you are subscribed to the Google
Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to [email protected].
To post to this group, send email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/em3006be99-c4bb-41a8-b2ee-b0cd2bf1d45f%40ssi-pathfinder.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google
Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to [email protected].
To post to this group, send email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/5705690D.9040705%40albertberry.com?utm_medium=email&utm_source=footer.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/em66e93373-84f4-4e36-b6df-6853c551e239%40ssi-pathfinder.
For more options, visit https://groups.google.com/d/optout.
