复制select a.i_checkno,通过 a.d_checkdate, b.s_name, b.s_code, b.i_age, c.s_name from lis_report a innerjoin comm_patient b on a.i_patientid = b.i_patientid innerjoin lis_code_dept c on b.i_dept = c.i_id where a.d_checkdate > 2008-11-01 and a.d_checkdate < 2008-11-30 and b.i_age>=80 and b.s_name like周% orderby a.d_checkdate desc 1.2.3.4.5.6.7.8.9.