Postgres Pro
Downloads
Home   >   mailing lists

Re: please give me select sqls examples to distinct these! - Mailing list pgsql-general

From David G. Johnston
Subject Re: please give me select sqls examples to distinct these!
Date
Msg-id CAKFQuwb-20mcoHmea_m_+u__dwDY3qhv1TTnR9TRSfhPnVokDw@mail.gmail.com
Whole thread Raw
In response to Re: please give me select sqls examples to distinct these!  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: please give me select sqls examples to distinct these!
List pgsql-general
Tree view
On Tue, Oct 25, 2022 at 8:22 AM David G. Johnston <david.g.johnston@gmail.com> wrote:
On Tue, Oct 25, 2022 at 7:06 AM Rob Sargent <robjsargent@gmail.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.

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: please give me select sqls examples to distinct these!
Next
From: Rob Sargent
Date:
Subject: Re: please give me select sqls examples to distinct these!