SELECT DISTINCT c.company_id,
FROM company c,
authority a,
authority_lob alob
WHERE c.company_id = a.company_id
AND a.authority_id = alob.authority_id
AND a.authority_status_id = 14
AND alob.lob_id IN (1, 4, 5, 44, 45)
ORDER BY c.company_nm
FROM company c,
authority a,
authority_lob alob
WHERE c.company_id = a.company_id
AND a.authority_id = alob.authority_id
AND a.authority_status_id = 14
AND alob.lob_id IN (1, 4, 5, 44, 45)
ORDER BY c.company_nm
想返回唯一的company_id
可以考虑group by