mybatis union和 choose 实例

select
tu.id as "userOid",
"1" as "teamMamger",
tu.name as "userName",
tu.phone_number as "phone",
tu.email as "email",
tdi.name as "teamName"
from t_customer_info tci
left join t_user tu on tu.id=tci.owner_bd
left join t_user_dept tud on tu.id=tud.user_id
left join t_dept_info tdi on tdi.id=tud.dept_id
<where>
    <if test="customerId!= null"> and tci.id=#{customerId}</if>
</where>
union all
select
a.user_oid as "userOid",
a.team_mamger as "teamMamger",
b.name as "userName",
b.phone_number as "phone",
b.email as "email",
d.name as "teamName"
from t_customer_team_em a
left join t_user b on b.id = a.user_oid
left join t_user_dept c on b.id=c.user_id
left join t_dept_info d on d.id=c.dept_id
<where>
    <choose>
        <when test="teamId!= null">
            and a.customer_team_oid=#{teamId}
        </when>
        <otherwise>
            and a.customer_team_oid is NULL
        </otherwise>
    </choose>
  </where>