• xmunk
    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