Viewing 5 posts - 1 through 5 (of 5 total)
I'll wait a bit longer before passing certification 😉
I have never needed to filter on another table that the "directly" concerned one within a join. And so never wondered if...
September 6, 2013 at 8:18 am
#1648105
GilaMonster (9/6/2013)
September 6, 2013 at 7:27 am
#1648066
btw, wouldn't it be better writing your example query more like :
SELECT * FROM t
WHERE (a<>0) and (b= 2 * a)
?
It will avoid the "CASE" term
September 6, 2013 at 7:07 am
#1648053
Thanks for answers but the fact is that I don't need this "o.type = 'abcd'" and if I had done this query by myself I would never have written this...
September 6, 2013 at 6:57 am
#1648051
Just went wrong due to the NULL value possibilty. 🙁
Some projects have already failed with such a lack of precision ... :w00t:
December 27, 2012 at 9:04 am
#1571902