am Mon, dem 08.10.2007, um 12:32:55 +0100 mailte Peter Childs folgendes: > > > On 08/10/2007, A. Kretschmer <[EMAIL PROTECTED]> wrote: > > am Mon, dem 08.10.2007, um 12:49:04 +0200 mailte Dani Castaños folgendes: > > Hi all! > > > > I want to put this three queries in only one... Take a look that the > > only thing that changes is the message_type_id. Any suggestions?? > > Yes, no problem, You can use UNION (ALL) for such. > > > > Not sure thats what he wants at all. Anyway Union all is going to produce a > very slow way of doing this needing to go back to the data 3 times where as > this only goes once.
Right, conditional statements are a proper solution for this. Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
