Архив форумов ЦИТФорума

[desyde]

SELECT Reservations.JOB_ID,Reservations.RGP_ID, AVG(Reservations.OCCUPANCY)
FROM TTE_RESERVATIONS Reservations,
TTE_JOBS Jobs
WHERE (Reservations.JOB_ID = Jobs.ID AND Reservations.CANCELLED = 'N')
AND jobs.JGP_ID = :1
GROUP BY Reservations.JOB_ID, Reservations.RGP_ID

Этот SELECT групируэт Reservations.RGP_ID и даже по значению NULL

[Valera]

WHERE (Reservations.JOB_ID = Jobs.ID AND Reservations.CANCELLED = 'N' AND Reservations.RGP_ID<>NULL)