in trying find basic details of doctor (name, address phone etc) youngest working in clinic, have not resigned.
i've gone through forums , best i've found use inner join, it's not returning information @ all.
select doctorid, surname, given, address, suburb, postcode, phone doctor inner join ( select max(dob) doctor resigned null); this code isn't working, appreciated.
an inner join requires on clause:
from doctor inner join ( select max(dob) max_dob doctor resigned null) filter on filter.max_dob = doctor.dob 