Bueno gente aqui voy otra vez.. con mis monologos
solucione el problema de esta manera
Código:
SELECT department.name,
SUM( IF( DATEDIFF( warrantyExpiry, CURDATE( ) ) <0, 1, 0 ) ) AS Expired,
SUM( IF( DATEDIFF( warrantyExpiry, CURDATE( ) ) >=0, 1, 0 )
AND IF( DATEDIFF( warrantyExpiry, CURDATE( ) ) <=365, 1, 0 ) ) AS ThisYear,
SUM( IF( DATEDIFF( warrantyExpiry, CURDATE( ) ) >365, 1, 0 ) ) AS OnTime,
COUNT( * ) AS total
FROM (
workstation
LEFT OUTER JOIN user ON ( workstation.fk_userID = user.pk_id )
LEFT OUTER JOIN wsdetails ON ( workstation.pk_workstationID = wsdetails.pkfk_workstationID )
INNER JOIN department ON ( user.fk_deptID = department.pk_id )
)
GROUP BY department.name
ORDER BY department.name
Es bastante interesante este caso y como se puede usar esos IFs con condiciones internas que en verdad no encontre en ningun tutorial dentro la web..
solo prueba y error
Gracias a los que me leyeron
;)