Re: Help with SQL statement

[David Fells]

SELECT
d1.TrainerID, d1.Date as startDate, d2.Date as endDate
FROM
details AS d1, details AS d2
WHERE
(d1.Date < d2.Date) AND
NOT EXISTS (SELECT * FROM details AS d3, details AS d4
WHERE (
d3.Date <= d4.Date AND
d4.Date = DATE_SUB(d3.Date, INTERVAL 1 DAY) AND
d3.Date BETWEEN DATE_ADD(d1.Date, INTERVAL 1 DAY) AND d2.Date)
OR (
d3.Date = DATE_SUB(d1.Date, INTERVAL 1 DAY) AND d3.Date < d1.Date)
OR (
d3.Date = DATE_ADD(d2.Date, INTERVAL 1 DAY) AND d3.Date > d2.Date))
GROUP BY
TrainerID


That should do it, I think...