MySQL SELECT IF 根据不同条件查询不同表返回数据

Control Flow Functions

SELECT *, IF(apptype=0, (
SELECT phone
FROM `mp_user`
WHERE id=l.user_id),(
SELECT phone
FROM `mp_company_admin`
WHERE id=l.user_id)) as t
FROM `mp_lading` l
WHERE id =315