----- Original Message ----- > From: "Paul Halliday" <paul.halli...@gmail.com> > > Is it OK to keep adding to those joins? In a view there could be say > 50 countries. The user can keep on adding more to exclude. So would I > just expand on the ANDs like so: > > AND map1.cc !='CA' AND map1.cc !='US' AND map1.cc !='LV'... ?
Yes, although "not in ()" is probably going to look a bit more manageable. I'm also not a big fan of putting where predicates in the join clause - it's a dirty trick - although in some cases it does shave quite a bit off the execution time. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org