Welcome to Software Development on Codidact!
Will you help us build our independent community of developers helping developers? We're small and trying to grow. We welcome questions about all aspects of software development, from design to code to QA and more. Got questions? Got answers? Got code you'd like someone to review? Please join us.
Activity for billkarwinâ€
| Type | On... | Excerpt | Status | Date |
|---|---|---|---|---|
| Edit | Post #289806 | Initial revision | — | about 1 year ago |
| Answer | — |
A: Are there best practices for sticking conditions in WHERE clauses vs the JOIN statement? Some condition require you to put conditions in the join clause. For example, if you're doing a LEFT OUTER JOIN, and you want to match all rows from table A with only the rows from table B with the corresponding id and another condition, then you must put the condition in the join clause. S... (more) |
— | about 1 year ago |