你只需要这3列,那么查询可以写成这样: select a.zgyj,c.selectname as 问题类别,f.selectname as 整改进度from formtable_main_19 a,hrmdepartment b, workflow_selectitem c,workflow_selectitem f,workflow_billfield d where a.bjdw=b.id and c.fieldid=d.id and f.fieldid=d.id and d.billid=-19 and a.wtlb=c.selectvalue and a.zgjd=f.selectvalue 不过,有可能你的查询写的有问题
你只需要这3列,那么查询可以写成这样: select a.zgyj,c.selectname as 问题类别,f.selectname as 整改进度from formtable_main_19 a,hrmdepartment b, workflow_selectitem c,workflow_selectitem f,workflow_billfield d where a.bjdw=b.id and c.fieldid=d.id and f.fieldid=d.id and d.billid=-19 and a.wtlb=c.selectvalue and a.zgjd=f.selectvalue 不过,有可能你的查询写的有问题 这个查询语句这个样写还是不对啊,查询结果还是我图上显示的那样
你只需要这3列,那么查询可以写成这样: select a.zgyj,c.selectname as 问题类别,f.selectname as 整改进度from formtable_main_19 a,hrmdepartment b, workflow_selectitem c,workflow_selectitem f,workflow_billfield d where a.bjdw=b.id and c.fieldid=d.id and f.fieldid=d.id and d.billid=-19 and a.wtlb=c.selectvalue and a.zgjd=f.selectvalue 不过,有可能你的查询写的有问题 我写出来啦,谢谢你的提示
你只需要这3列,那么查询可以写成这样: select a.zgyj,c.selectname as 问题类别,f.selectname as 整改进度from formtable_main_19 a,hrmdepartment b, workflow_selectitem c,workflow_selectitem f,workflow_billfield d where a.bjdw=b.id and c.fieldid=d.id and f.fieldid=d.id and d.billid=-19 and a.wtlb=c.selectvalue and a.zgjd=f.selectvalue 不过,有可能你的查询写的有问题 我写出来啦,谢谢你的提示呵呵,那就好哈
你只需要这3列,那么查询可以写成这样:
select a.zgyj,c.selectname as 问题类别,f.selectname as 整改进度from formtable_main_19 a,hrmdepartment b,
workflow_selectitem c,workflow_selectitem f,workflow_billfield d
where a.bjdw=b.id and c.fieldid=d.id and f.fieldid=d.id and d.billid=-19
and a.wtlb=c.selectvalue and a.zgjd=f.selectvalue
不过,有可能你的查询写的有问题
你只需要这3列,那么查询可以写成这样:
select a.zgyj,c.selectname as 问题类别,f.selectname as 整改进度from formtable_main_19 a,hrmdepartment b,
workflow_selectitem c,workflow_selectitem f,workflow_billfield d
where a.bjdw=b.id and c.fieldid=d.id and f.fieldid=d.id and d.billid=-19
and a.wtlb=c.selectvalue and a.zgjd=f.selectvalue
不过,有可能你的查询写的有问题
这个查询语句这个样写还是不对啊,查询结果还是我图上显示的那样
你只需要这3列,那么查询可以写成这样:
select a.zgyj,c.selectname as 问题类别,f.selectname as 整改进度from formtable_main_19 a,hrmdepartment b,
workflow_selectitem c,workflow_selectitem f,workflow_billfield d
where a.bjdw=b.id and c.fieldid=d.id and f.fieldid=d.id and d.billid=-19
and a.wtlb=c.selectvalue and a.zgjd=f.selectvalue
不过,有可能你的查询写的有问题
我写出来啦,谢谢你的提示
你只需要这3列,那么查询可以写成这样:
select a.zgyj,c.selectname as 问题类别,f.selectname as 整改进度from formtable_main_19 a,hrmdepartment b,
workflow_selectitem c,workflow_selectitem f,workflow_billfield d
where a.bjdw=b.id and c.fieldid=d.id and f.fieldid=d.id and d.billid=-19
and a.wtlb=c.selectvalue and a.zgjd=f.selectvalue
不过,有可能你的查询写的有问题
我写出来啦,谢谢你的提示呵呵,那就好哈