David Perron schrieb:
Hi Sebastian-
Wanted to follow up on this. I figured out the problem. You actually
have to use the LEAST & GREATEST operators when comparing multiple
values, this statement works perfectly.
LEAST(EndDays,Q2EndDays) - GREATEST(Q2StartDays,StartDays) as DaysInQ2,
Thanks again for the tip! Have a great day.
oh, yes, for sure, sorry, my mistake! :-)
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
