I have been working on this for a while and just can't seem to figure out a way to make it work. Let me explain what I need to do. I have 2 tables, Patient and PatientCharges. There is one record for each patient in the Patient table, but there may be multiple records per patient in the patient charges table, representing each time the patient has visited the doctor. What I need to do is find the oldest date of service for each patient in the patientcharges table and place that value in the first visit date field for each patient in the patient table.
Patient_number Last_Name First_Name First_Visit_Date
108 Drews Mike 01/01/1899
205 Samms Deb 01/01/1899