使用的MySQL不支持子查询的话,要用连接(join)方案,或其他的查询语句: select filelist.id from filelist,orguser where filelist.ownerid=orguser.userid and orguser.orgid=1;join 方案: select filelist.id from filelist left join orguser on filelist.ownerid=orguser.userid where orgid=1;
关于mysql的子查询,如果你的版本不支持。可以用 LEFT JION 重新编写。 SELECT FILELIST.* FROM FILELIST LEFT JION ORGUER ON FILELIST.OWNERID=ORUSER.USERID WHERE ORGID=1
select filelist.id from filelist,orguser where filelist.ownerid=orguser.userid and orguser.orgid=1;join 方案:
select filelist.id from filelist left join orguser on filelist.ownerid=orguser.userid where orgid=1;
SELECT FILELIST.* FROM FILELIST LEFT JION ORGUER ON FILELIST.OWNERID=ORUSER.USERID WHERE ORGID=1