----- Original Message -----
> From: "Paul Halliday" <paul.halliday@stripped>
>
> 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
