Active Family Mailing List for Open Dental

SELECT
    pg.FName,
    pg.LName,
    pg.Address,
    pg.Address2,
    pg.City,
    pg.State,
    pg.Zip
FROM appointment a
LEFT JOIN patient p ON a.PatNum = p.PatNum
LEFT JOIN patient pg ON p.Guarantor = pg.PatNum
WHERE
    p.PatStatus = 0
    AND a.AptStatus = 2
    AND DATE(a.AptDateTime) BETWEEN CURDATE() - INTERVAL 12 MONTH AND CURDATE()
GROUP BY pg.PatNum
ORDER BY
    pg.LName,
    pg.FName
;