MySQL Group Count

By , February 25, 2012 9:58 AM

SELECT
clog.AppointmentDate,
Count(clog.CallID)
FROM
clog
WHERE
clog.Patientseen = ‘1’ AND
clog.AppointmentDate >= ‘2007-12-01’ AND
clog.AppointmentDate <= ‘2007-12-23’ GROUP BY
clog.AppointmentDate

DELETE QUERY WITH 2 TABLES

By , February 8, 2012 10:57 PM

MYSQL DELETE QUERY OVER MULTIPLE TABLES

 

DELETE calllog
FROM calllog
JOIN locum ON calllog.LocumID = locum.LocumID
WHERE locum.LastName = “ANAME”

Thomas Challenger Thomas Challenger