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

2019独角兽企业重金招聘Python工程师标准>>>

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

转载于:https://my.oschina.net/yeahlife/blog/1837516