I think it matters specially with big queries. When you have dozens of tables, i... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		forinti 9 months ago \| parent \| context \| favorite \| on: INNER JOIN ON vs WHERE clause (2009) I think it matters specially with big queries. When you have dozens of tables, it really helps to separate the joins from the where clause.

chrisandchris 9 months ago [–]

For myself, this is even with a couple of tables valid. I think of the query as "looking up references in a book". Therefore I write global filters in the WHERE and stuff specific to a table in the ON condition.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact