Re: [GENERAL] Different LEFT JOIN results with and without USING

Alexander Farber writes: > why do these queries please return different results? > FROMwords_scores s > LEFT JOIN words_games g ON s.gid = g.gid > AND s.uid = 1 In this one, "s.uid = 1" is part of the LEFT JOIN condition, so it never

[GENERAL] Different LEFT JOIN results with and without USING

Good afternoon, why do these queries please return different results? SELECT s.gid, TO_CHAR(g.created, 'DD.MM.'), TO_CHAR(g.finished, 'DD.MM.'), LENGTH(s.word), s.score FROMwords_scores s LEFT JOIN words_games g ON s.gid = g.gid