>select rule.* from rule INNER JOIN users on rule.cuserid = users.cid where Users.cID = ?vp_cuserid ; >UNION all; >select rule.* from rule INNER JOIN users on rule.cgroupid = users.cgroupid where Users.cID = ?vp_cuserid and rule.cgroupid <> "ZZZZZZ" >>
select * from rule WHERE cuserid = ?vp_cuserid OR cgroupid IN ( SELECT cgroupid FROM Users WHERE cID = ?vp_cuserid AND cgroupid <> "ZZZZZZ" )