急求sql查询语句
急求求一个sql查询语句
求一条sql语句，gc表字段有gh,uploadflag,img表字段有gh,tagid,uploadflag,pic表字段有gh,tagid,uploadflag.
现在需要查询出来gc表中uploadflag=0并且img的tagid=0,uploadflag=1和tagid=1,uploadflag=1,表pic的tagid=1,uploadflag=1,
换个说法就是查询出gc表中uploadflag=0并且满足有3张照片已经上传的gh
不能用存储过程实现，因为数据库操作类不支执存储过程
------解决思路----------------------
求一条sql语句，gc表字段有gh,uploadflag,img表字段有gh,tagid,uploadflag,pic表字段有gh,tagid,uploadflag.
现在需要查询出来gc表中uploadflag=0并且img的tagid=0,uploadflag=1和tagid=1,uploadflag=1,表pic的tagid=1,uploadflag=1,
换个说法就是查询出gc表中uploadflag=0并且满足有3张照片已经上传的gh
不能用存储过程实现，因为数据库操作类不支执存储过程
------解决思路----------------------
SELECT AA.GH
FROM GC AA
JOIN IMG BB
ON AA.GH = BB.GH
JOIN PIC CC
ON AA.GH = CC.GH
WHERE AA.UPLOADFLAG = 0
AND ((BB.TAGID = 0 AND BB.UPLOADFLAG = 1) OR
(BB.TAGID = 1 AND BB.UPLOADFLAG = 1))
AND CC.TAGID = 1
AND CC.UPLOADFLAG = 1