http://www.bigdbahead.com/?p=187 Database Brain Power! Mon, 29 Mar 2010 22:08:57 +0000 http://wordpress.org/?v=2.9.2 hourly 1 http://www.bigdbahead.com/?p=187&cpage=1#comment-1331 Yves Trudeau Sun, 29 Mar 2009 14:56:49 +0000 http://www.bigdbahead.com/?p=187#comment-1331 That example is fairly simple. I can show you queries joining more than 10 tables. With the IN and NOT IN clauses, I can say in a few seconds what the query is returning but with JOIN and OUTER JOIN the reading is not as trivial. You are right that it is probably a more procedural way of seeing things, my point is just that it is easier to read. That example is fairly simple. I can show you queries joining more than 10 tables. With the IN and NOT IN clauses, I can say in a few seconds what the query is returning but with JOIN and OUTER JOIN the reading is not as trivial. You are right that it is probably a more procedural way of seeing things, my point is just that it is easier to read.

]]> http://www.bigdbahead.com/?p=187&cpage=1#comment-1219 KevinF Tue, 17 Mar 2009 17:26:12 +0000 http://www.bigdbahead.com/?p=187#comment-1219 Oops, sorry! Yves, that is. Oops, sorry! Yves, that is.

]]> http://www.bigdbahead.com/?p=187&cpage=1#comment-1218 KevinF Tue, 17 Mar 2009 17:12:20 +0000 http://www.bigdbahead.com/?p=187#comment-1218 Matt, thanks for the heads-up. Does mysql pre-6.0 ever consider see subquery clauses as independent? I gave up trying. Matt, thanks for the heads-up.
Does mysql pre-6.0 ever consider see subquery clauses as independent? I gave up trying.

]]>