• xmunk@sh.itjust.works
      link
      fedilink
      arrow-up
      9
      ·
      1 year ago

      I’ve seen both approaches and I think they’re both quite reasonable. An indented join is my preference since it makes sub queries more logically indented… but our coding standards allow either approach. We’ve even got a few people that like

      FROM foo
      JOIN bar ON foo.id = bar.fooid
      JOIN baz ON bar.id = baz.barid