On Tue, Oct 25, 2022 at 8:22 AM David G. Johnston <david.g.johnston@xxxxxxxxx> wrote:
On Tue, Oct 25, 2022 at 7:06 AM Rob Sargent <robjsargent@xxxxxxxxx> 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.
