select a.user_id,a.subject,a.action,b.membername,b.unitcode
from gfa_ra_user_cert_req a ,gfa_ra_gcb_company b,
(select count(membername) as num,membername as mem from gfa_ra_gcb_company group by membername having (num >1)) c
where b.membername = c.mem and a.user_id = b.id ORDER by b.membername;
select b.id,b.membername,b.unitcode
from gfa_ra_gcb_company b,
(select count(membername) as num,membername as mem from gfa_ra_gcb_company group by membername having (num >1)) c
where b.membername = c.mem ORDER by b.membername;
from gfa_ra_user_cert_req a ,gfa_ra_gcb_company b,
(select count(membername) as num,membername as mem from gfa_ra_gcb_company group by membername having (num >1)) c
where b.membername = c.mem and a.user_id = b.id ORDER by b.membername;
select b.id,b.membername,b.unitcode
from gfa_ra_gcb_company b,
(select count(membername) as num,membername as mem from gfa_ra_gcb_company group by membername having (num >1)) c
where b.membername = c.mem ORDER by b.membername;