From: Yanis Guenane
Date: July 30 2012 7:58pm
Subject: Re: Consulta
List-Archive: http://lists.mysql.com/mysql-es/3938
Message-Id: <CANRLFhr7qUHW23OprB7qUzsOBR6ChEDshM+q99-3uqqC3Z0sLw@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=047d7b6041ba05189304c6117ed5

--047d7b6041ba05189304c6117ed5
Content-Type: text/plain; charset=ISO-8859-1

Esto si,  te daria el resultado que quieres.

On Mon, Jul 30, 2012 at 9:56 PM, Juan Vallini <Juan_Vallini@stripped>wrote:

> Ok, lo que pasa que cone l IDViajes, agrupo por Viajes
>
>
> SELECT
> IDViajes,
> IF(IDTipoReserva = 1,COUNT(IDViajesDetalle),0) as Confirmado,
> IF(IDTipoReserva = 2,COUNT(IDViajesDetalle),0) as Condicional,
> IF(IDTipoReserva = 3,COUNT(IDViajesDetalle),0) as Cancelado
> FROM Viajesdetalle
> WHERE (IDViajes = 7)
> GROUP BY IDViajes;
>
>
>
> asi????
>
>
> Saludos
> ----- Original Message ----- From: "Yanis Guenane" <yguenane@stripped>
> To: "Juan Vallini" <Juan_Vallini@stripped>
> Cc: <mysql-es@stripped>
> Sent: Monday, July 30, 2012 4:50 PM
> Subject: Re: Consulta
>
>
>  Perdona mi espanol, intente traducirlo del ingles.
>>
>> Queria decir "obligatorio".
>>
>> On Mon, Jul 30, 2012 at 9:47 PM, Juan Vallini
>> <Juan_Vallini@stripped>**wrote:
>>
>>  Yanis:
>>>
>>>    Perdona mi ignorancia, que seria Mandatorio.
>>>
>>> Saludos
>>> ----- Original Message ----- From: "Yanis Guenane" <yguenane@stripped>
>>> To: "Juan Vallini" <Juan_Vallini@stripped>
>>> Cc: <mysql-es@stripped>
>>> Sent: Monday, July 30, 2012 4:42 PM
>>> Subject: Re: Consulta
>>>
>>>
>>>  Depende de si el GROUP BY IDTipoReserva es mandatorio para ti. Si lo es,
>>>
>>>> es
>>>> impossible hacer lo que tu quieres.
>>>>
>>>> Sino
>>>>
>>>> SELECT
>>>>  IDViajes,
>>>>  COUNT(IF(IDTipoReserva = 1, IDViajesDetalle, 0)) as Confirmado,
>>>>  COUNT(IF(IDTipoReserva = 2, IDViajesDetalle, 0)) as Condicional,
>>>>  COUNT(IF(IDTipoReserva = 3, IDViajesDetalle, 0)) as Cancelado
>>>> FROM Viajesdetalle
>>>> WHERE (IDViajes = 7)
>>>> GROUP BY IDViajes;
>>>>
>>>> deberia funcionar.
>>>>
>>>> Un saludo,
>>>>
>>>>
>>>> 2012/7/30 Juan Vallini <Juan_Vallini@stripped>
>>>>
>>>>  Buenas:
>>>>
>>>>>
>>>>>     Quisiera saber si pueddo dejar esta consulta en un solo registro y
>>>>> no
>>>>> en tres:
>>>>>
>>>>> SELECT
>>>>>   IDViajes,
>>>>>   IF(IDTipoReserva = 1,COUNT(IDViajesDetalle),0) as Confirmado,
>>>>>   IF(IDTipoReserva = 2,COUNT(IDViajesDetalle),0) as Condicional,
>>>>>   IF(IDTipoReserva = 3,COUNT(IDViajesDetalle),0) as Cancelado
>>>>> FROM Viajesdetalle
>>>>> WHERE (IDViajes = 7)
>>>>> GROUP BY IDViajes,IDTipoReserva;
>>>>>
>>>>> Este es el resultado.
>>>>>       IDViajes Confirmado Condicional Cancelado
>>>>>       7 1 0 0
>>>>>       7 0 1 0
>>>>>       7 0 0 1
>>>>>
>>>>>
>>>>>
>>>>> Quisiera que quede asi:
>>>>>       IDViajes Confirmado Condicional Cancelado
>>>>>       7 1 1 1
>>>>>
>>>>>
>>>>>
>>>>>       Gracias, espero haber sido claro.
>>>>>
>>>>>       SALUDOS
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>> --
>>>> *Yanis Guenane*
>>>>
>>>>
>>>>
>>>
>>
>> --
>> *Yanis Guenane*
>>
>>
>


-- 
*Yanis Guenane*

--047d7b6041ba05189304c6117ed5--