Skip to main content

Dean H.

Member since Oct 27, 2014

Recent Blog Comments By Dean H.

  • The Anatomy Of An INNER JOIN Query In SQL

    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 »

I believe in love. I believe in compassion. I believe in human rights. I believe that we can afford to give more of these gifts to the world around us because it costs us nothing to be decent and kind and understanding. And, I want you to know that when you land on this site, you are accepted for who you are, no matter how you identify, what truths you live, or whatever kind of goofy shit makes you feel alive! Rock on with your bad self!
— Ben Nadel