selecting last record that matches two tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have table call "Patient" with patient code as primary key, and has an
attribute "status." Another table is "Patient History" (an associate table)
with patient code and admission date as primary key. I want to make a query
to select the last record of patients' history while the "status" are equal
to "I" with these two table. wut do i need to do to make this happen?
 
Back
Top