Member since Oct 27, 2014
- Profile: /members/12386-dean-h.htm
- Comments: 1
Recent Blog Comments By Dean H.
Posted on Oct 27, 2014 at 3:13 PM
If a query is joining multiple tables, each of which have some filter conditions, I find the clearest way to handle it is to use a WITH clause, apply filters to the individual tables, then reference the aliases in the main query. For example: WITH t1 AS ( SELECT * from table1 WHERE ... ), t2 ... read more »