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
解决方案 »
- 请高手回答复杂的SQL语句
- 谁能帮我看看这条SQL语句? 无法理解!
- 第一次用存储过程
- 测试mysql.Access denied for user 'ODBC'@'localhost' (using password: NO) 怎样解决?
- 通过查询更新
- 请教关于mysql直接拷贝的数据库导出的问题,提示1045,情况有点特殊
- [MYSQL]还是乱码问题。jsp+mysql4.1.X+tomcat5.028 基本编码都保持一直了 还是不成功。详细。。。。
- 这个select语句我服了you,请大家进来坐坐,看看它倒底怎么了
- 用phpmyadmin管理mysql的时候,怎么屏蔽掉root的权限啊?
- 哪位高手熟悉mysql
- 请问下面的错误怎么解决?
- 真的搞不懂啊!(200分)
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