Check the keyword DECODE, the equivalent of CASE...WHEN. Regards, Martin
----- Original Message ----- From: "henry_interiano" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, March 24, 2003 1:19 PM Subject: SQL Case > As I make the following SQL in Sapdb. of this form it is made in > SQLSERVER > > Select Raza.Nombre_Raza, > Animal.Codigo_Sexo, > Animal.Numero_Lote_Ceba, > Animal.Codigo_Destino_Inicial, > Count( Raza.Nombre_Raza ) As Animxlote, > Case Animal.Codigo_Destino_Inicial > When 1 Then Sum(1) > End As Seleccionados, > Case Animal.Codigo_Destino_Inicial > When 2 Then Sum(1) > End As Matadero > From Camada > Inner Join Raza > On Camada.Codigo_Raza = Raza.Codigo_Raza > Inner Join Animal > On Camada.Codigo_Camada = Animal.Codigo_Camada > Where Animal.Codigo_Destino_Inicial <> 0 > Group By Raza.Nombre_Raza, Animal.Codigo_Sexo, > Animal.Numero_Lote_Ceba, Animal.Codigo_Destino_Inicial > Order By Raza.Nombre_Raza, Animal.Numero_Lote_Ceba > > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
