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
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