select vn.vstdate,ds.screen_datetime,ds.vn,vn.hn,concat(pname,fname,' ',lname)as ptname,vn.pdx,vn.sex,vn.age_y,p.name as pttypename,
pt.informaddr,o.name as doctorscreen ,d2.depression_screen_evaluate_name ,d3.suicide_screen_evaluate_name,ds2.depression_status_name
from depression_screen ds
left outer join vn_stat vn on vn.vn=ds.vn
left outer join patient pt on pt.hn=vn.hn
left outer join pttype p on p.pttype=vn.pttype
left outer join opduser o on o.loginname=ds.staff
left outer join depression_screen_evaluate d2 on d2.depression_screen_evaluate_id = ds.depression_screen_evaluate_id
left outer join suicide_screen_evaluate d3 on d3.suicide_screen_evaluate_id = ds.suicide_screen_evaluate_id
left outer join patient_depression pd on pd.hn=vn.hn
left outer join depression_status ds2 on ds2.depression_status_id=pd.depression_status_id
order by ds.vn desc