Is there a patient report that lists all patients by insurance group number?
Select All Code:
1 2 3 4 5 6 7 8 | SELECT a.payorname,a.insgroup,b.lastname,b.firstname,b.id FROM rv_policies a JOIN patients b ON a.ptnum = b.ptnum WHERE today() BETWEEN COALESCE(a.active,'1900-01-01') AND COALESCE(a.inactive,'2100-12-31') ORDER BY payorname, insgroup, b.lastname, b.firstname, b.id |