On 03/07/2013 10:27 AM, Harald Leithner wrote: > oh and > >> Does that provide the same information as the UNION > > Yes it provides the same information but it could happend that it > doesnot return 3 rows, for example if you have not revent_flag messages > it doesn't return the count 0 so you have to preset the variable for 0 > vaules.
I still don't understand. Can you provide some query output as an example? -- ________________________________________________________________ Paul J Stevens pjstevns @ gmail, twitter, skype, linkedin * Premium Hosting Services and Web Application Consultancy * www.nfg.nl/i...@nfg.nl/+31.85.877.99.97 ________________________________________________________________ _______________________________________________ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail