any 的使用 和in 的使用:
SELECT
tt.ID
FROM
uaa_department tt
WHERE
tt.PATH LIKE ANY ( SELECT '%' || rr.deparment_id || '%' FROM uaa_employee_leader rr WHERE rr.corp_id = 3 AND rr.employee_id = 145767745412143104 )
zxy-come-on 2021-01-22 17:10 原文
any 的使用 和in 的使用:
SELECT
tt.ID
FROM
uaa_department tt
WHERE
tt.PATH LIKE ANY ( SELECT '%' || rr.deparment_id || '%' FROM uaa_employee_leader rr WHERE rr.corp_id = 3 AND rr.employee_id = 145767745412143104 )