Re: partial JOIN (was: ID column naming convention) - Mailing list pgsql-general

W dniu 24.10.2015 o 15:00, David G. Johnston pisze:
> On Sat, Oct 24, 2015 at 6:41 AM, Rafal Pietrak <rafal@ztk-rp.eu
> <mailto:rafal@ztk-rp.eu>>wrote:
[----------------------]
>
> ​Using explicit column names is expected - using "*" in non-trivial and
> production queries is not.
>
> You can move the aliases if you would like.
>
> SELECT *
> FROM tablea (col1, col2, col4)
> JOIN tableb AS tb1 (col1, col3, col5) USING (col1)
> JOIN tableb AS tb2​
>
> ​(col1, col6, col7) USING (col1)

I knew there must have been something like this.

thenx,

-R