Comments (0)

By admin, February 25, 2012 9:58 AM

SELECT
table1.AppointmentDate,
Count(table1.IDfield)
FROM
table1
WHERE
table1.seen = ’1′ AND
table1.AppointmentDate >= ’2007-12-01′ AND
table1.AppointmentDate GROUP BY
table1.AppointmentDate

Comments (0)

By admin, 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”