and `uid` in(`id` from `xinhu_admin` where `companyid`=1)

条件在哪里改造吗？

[error sql]

a.*,b.`name`,b.`deptname` from `xinhu_kqdkjl` a left join `xinhu_userinfo` b on a.uid=b.id where 1=1 and `uid` in(`id` from `xinhu_admin` where `companyid`=1) order by id desc limit 0,15

[reason]

mysqlierror:column 'uid' in in/all/any subquery is ambiguous

[url]

http://oa.51rnds.com/index.php?a=publicstore&m=kaoqin&d=main&ajaxbool=true&rnd=177897

[post]

[tablename_abc]:yp0bg0pd0gdp0yp0bd0ggz0ggb012

[defaultorder]:

[keywhere]:

[where]:

[sort]:id

[dir]:desc

[loadci]:5

[storebeforeaction]:

[storeafteraction]:kqdkjlaftershow

[modenum]:kqdkjl

[start]:0

[page]:1

[limit]:15

[atype]:all

[img,{fileurl}/img/60499.png,700]

原创文章，禁止转载复制，信呼OA官网保留一切知识产权。