/* The following is a list of sample queries that could be used after the system /* is implimented SELECT patient.Patient_ID, patient.Fname, patient.Lname, invoice.Balance FROM Patient, Invoice WHERE invoice.Balance = '0' SELECT patient.Patient_ID, patient.Fname, patient.Lname, Visit.Visit_ID FROM Patient, Invoice WHERE Patient.Patient_ID = Visit.Visit_ID Select visit_ID FROM Visit WHERE TypeOfVisit = 'Scheduled' These are simply examples of how to query... the first shows a way to find unpaid balances, the second shows a way to get a patient's history inventory, third is a way to check if the visit has an appointment, or was unscheduled.