Open Dental Forum

Code: Select all

SELECT
    ap.AptDateTime,
    prov.Abbr                   AS provider,
    pat.PatNum,
    pat.LName,
    pat.FName,
    ap.ClinicNum,
    CASE ap.AptStatus
        WHEN 1 THEN 'Scheduled'
        WHEN 2 THEN 'Complete'
        WHEN 3 THEN 'UnschedList'
        WHEN 4 THEN 'ASAP'
        WHEN 6 THEN 'Planned'
    END                         AS apt_status,
    ap.ProcDescript,
    ap.Note
FROM appointment ap
    INNER JOIN patient  pat  ON pat.PatNum   = ap.PatNum
    LEFT  JOIN provider prov ON prov.ProvNum = ap.ProvNum
WHERE ap.AptDateTime >= '2026-01-01'
  AND ap.AptDateTime <  '2026-02-01'
  AND ap.AptStatus   <> 5
  -- one provider only? uncomment and set the number:
  -- AND ap.ProvNum    = 3
ORDER BY ap.AptDateTime;