Re: please give me select sqls examples to distinct these!

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Rob Sargent <robjsargent(at)gmail(dot)com>
Cc: jacktby(at)gmail(dot)com, pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: please give me select sqls examples to distinct these!
Date: 2022-10-25 15:24:32
Message-ID: CAKFQuwb-20mcoHmea_m_+u__dwDY3qhv1TTnR9TRSfhPnVokDw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Oct 25, 2022 at 8:22 AM David G. Johnston <
david(dot)g(dot)johnston(at)gmail(dot)com> wrote:

> On Tue, Oct 25, 2022 at 7:06 AM Rob Sargent <robjsargent(at)gmail(dot)com> wrote:
>
>>
>>
>> 2: select * from table join table b on Id = idb
>>
>>
>>
> #2 is probably conceptually correct but in this context should be written
> as:
>
>
Actually, a join is NOT conceptually correct here - the output columns for
"SELECT *" will be wrong.

David J.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rob Sargent 2022-10-25 15:56:26 Re: please give me select sqls examples to distinct these!
Previous Message David G. Johnston 2022-10-25 15:22:44 Re: please give me select sqls examples to distinct these!