On 10/25/22 09:58, David G. Johnston wrote:
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.
Yeah, sorry. Meant to distinguish to two "table" defs in some way.
