SQL: Accounts with No Guarantor

About

This report looks at all patient charts who do not have a guarantor assigned. It also lists if they have a balance and the status of the account.

A sample image of this SQL report run in the Database Viewer is shown below:

Caveats

None.

Code

To highlight and copy the code below to your clipboard, simply click the Copy button.

select patno, fname, lname, guarantor_id,copaybal, status_pat from register
where patno >99 and fname is not null and guarantor_id = 0
order by guarantor_id