select h_id,h_liushui,h_title,h_wenhao,h_class,h_date,h_qianshou,h_unit,h_miji,h_huanji,h_file,h_zhengwen1 from shouwen ,shouwenhuifu
where h_jieshou like '%技术处%' or
(h_id in=huifu_id and
(chuliUser like '%管理员%' or chuliChushi like '%技术处%' ))
order by h_id
where h_jieshou like '%技术处%' or
(h_id in=huifu_id and
(chuliUser like '%管理员%' or chuliChushi like '%技术处%' ))
order by h_id
shouwen.h_id,shouwen.h_liushui,shouwen.h_title,shouwen.h_wenhao,shouwen.h_class,shouwen.h_date,
shouwen.h_qianshou,shouwen.h_unit,shouwen.h_miji,shouwen.h_huanji,shouwen.h_file,shouwen.h_zhengwen1
FROM
shouwen
LEFT JOIN shouwenhuifu ON shouwen.h_id = shouwenhuifu.huifu_id
WHERE
shouwen.h_jieshou like '%技术处%'
OR (shouwenhuifu.chuliUser like '%管理员%' or shouwenhuifu.chuliChushi like '%技术处%')
ORDER BY
shouwen.h_id