$sql="select per.id,pay.eid,mec.eid,rec.eid,* from employee_personal_information per,employee_payroll pay,employee_medical_information med,employee_recommend rec where per.id=pay.eid and per.id=med.eid and per.id=rec.eid and per.id=".$_GET['cID'];
提示
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '* from employee_personal_information per,employee_payroll pay,employee_medical_i' at line 1select per.id,pay.eid,mec.eid,rec.eid,* from employee_personal_information per,employee_payroll pay,employee_medical_information med,employee_recommend rec where per.id=pay.eid and per.id=med.eid and per.id=rec.eid and per.id=2[TEP STOP]
提示
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '* from employee_personal_information per,employee_payroll pay,employee_medical_i' at line 1select per.id,pay.eid,mec.eid,rec.eid,* from employee_personal_information per,employee_payroll pay,employee_medical_information med,employee_recommend rec where per.id=pay.eid and per.id=med.eid and per.id=rec.eid and per.id=2[TEP STOP]
解决方案 »
- windows下的postgresql自定义类型和函数的问题
- 改写一个触发器 应该很简单
- 求写一查询语句
- MYSQL安装失败
- 关于mysql登录问题
- 计算列的简单问题
- 插入mysql数据库报Incorrect string value: '\xF0\x9F\x90\x82'错误
- 如何根据一组ID查询并增加一列显示名称
- 创建触发器后不能进行修改操作,Can't update table 'psxt_user' in stored function/trigger because
- 一个mysql分页的问题
- handlersocket无法安装在二进制版本mysql下面吗?
- 一个视图同步2个表内容主键重复怎么解决.有代码
WHERE per.id=pay.eid AND per.id=med.eid AND per.id=rec.eid AND per.id=2
1054 - Unknown column 'per.id' in 'field list'select *,per.id,pay.eid,mec.eid,rec.eid from employee_personal_information per,employee_payroll pay,employee_medical_information med,employee_recommend rec where per.id=pay.eid and per.id=med.eid and per.id=rec.eid and per.id=2[TEP STOP]