Re: Getting info from 2 tables


Syntactic Confectionery Delight
	PerlMonks

Re: Getting info from 2 tables

by Cine (Friar)

on Jul 30, 2002 at 20:15 UTC ( [id://186347]=note: print w/replies, xml )

Need Help??

in reply to Getting info from 2 tables

SELECT SiteWideName,
sum(IF(notifAlarmLog.UTimeStart - notifAlarmLog.UTimeStop) < 2,1,0)) a
+s less2,
sum(IF(notifAlarmLog.UTimeStart - notifAlarmLog.UTimeStop) > 2 && noti
+fAlarmLog.UTimeStart - notifAlarmLog.UTimeStop) < 10,1,0)) as more2le
+ss10,
sum(IF(notifAlarmLog.UTimeStart - notifAlarmLog.UTimeStop) > 10,1,0)) 
+as more10
 FROM notifAlarmLog, fillEventsT WHERE
notifAlarmLog.UTimeStart < fillEventsT.rhicTimeUS-10 AND
notifAlarmLog.UTimeStart > fillEventsT.rhicTimeUS-10 AND
(fillEventsT.event = 'ev-bquench' OR fillEventsT.event = 'ev-yquench')
GROUP BY SiteWideName
[download]