SELECT xr.xn,d.name AS doctor_name,x.xray_items_name
, t.name AS type_name
, xr.clinical_information ,xr.confirm ,s.name AS side_name
FROM xray_report xr
LEFT OUTER JOIN xray_items x ON x.xray_items_code=xr.xray_items_code
LEFT OUTER JOIN doctor d ON d.code=xr.request_doctor
LEFT OUTER JOIN xray_type t ON t.xray_type = xr.xray_type
LEFT OUTER JOIN xray_side s ON s.xray_side = xr.xray_side
WHERE xr.xn = 999