Sorry, to clarify, not everything is in all caps. I’ll append my prefered syntax below
WITH foo AS (
SELECT id, baz.binid
FROM
bar
JOIN baz
ON bar.id = baz.barid
)
SELECT bin.name, bin.id AS binid
FROM
foo
JOIN bin
foo.binid = bin.id
The above is some dirt simple SQL, when you get into report construction things get very complicated and it pays off to make sure the simple stuff is expressive.
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
Sorry, to clarify, not everything is in all caps. I’ll append my prefered syntax below
WITH foo AS ( SELECT id, baz.binid FROM bar JOIN baz ON bar.id = baz.barid ) SELECT bin.name, bin.id AS binid FROM foo JOIN bin foo.binid = bin.idThe above is some dirt simple SQL, when you get into report construction things get very complicated and it pays off to make sure the simple stuff is expressive.
You indent your JOIN? Why on earth? It lives in the same context as the SELECT.
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.baridActually not. It’s part of the FROM
That double indented from is hurting me
deleted by creator
Um you forgot the semicolon before with assuming there isn’t one in the previous statement. Syntax error. Code review failed
There’s no way we’re running in multi statement mode… I like my prepared queries, thank you very much.