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

On 10/25/22 09:24, David G. Johnston wrote:
> 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.
>
OK.  TBH I thought this was the JOOQ list! Didn't notice the typedef. 
So this is all about exact match "tables".

I suppose my #2 could be framed as
select a* from table as a join table as b on a.<criteria> = b.<criteria>
to be a functional equivalent of INTERSECT?