Lab Cases With Fees in Open Dental

SET
    @StartDate = '2019-01-01',
    @EndDate = '2019-06-30'
;
SELECT
    p.LName,
    p.FName,
    a.ProcDescript,
    lb.Description LabName,
    l.LabFee,
    l.ProvNum LabProv,
    a.ProvNum AptProv
FROM labcase l
LEFT JOIN laboratory lb ON l.LaboratoryNum = lb.LaboratoryNum
LEFT JOIN appointment a ON l.AptNum = a.AptNum
LEFT JOIN patient p ON l.PatNum = p.PatNum
WHERE
    DATE(a.AptDateTime) BETWEEN @StartDate AND @EndDate
;