sql - Selecting last occurence of row from table -

I want to select the patient details from the discharge table for 2015-03-16 and select their respective login details from the admission table. .

Discharge table

Access Table

. These two tables should be selected using the query that is used in the query with the line red mark

query done:

  Do a.pat_id, a.pat_name, b.admit_date, b.admit_time, b.diagnosis, b.r_name, a.dis_date, discharge_details one from a.dis_time, admission_Details b where dis_date = convert (date, dateADD (day, - 1, GETDATE ()) and a.pat_id = b.patient_id and b.Admit_status = 'Discharged'  

Output Received:

expected output:

Please modify your query .. Help me with suggestions

itemprop = "text">

externally are applicable in situations like this: