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
