On Tue, Oct 25, 2022 at 8:56 AM Rob Sargent <robjsarg...@gmail.com> wrote:
> On 10/25/22 09:24, David G. Johnston wrote: > > On Tue, Oct 25, 2022 at 8:22 AM David G. Johnston < > david.g.johns...@gmail.com> wrote: > >> On Tue, Oct 25, 2022 at 7:06 AM Rob Sargent <robjsarg...@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. > > 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? > SELECT DISTINCT a.* David J.