MySQL CASE WHEN 根据一个表的字段值不同关联查询两张不同的表

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

Control Flow Functions

• CASE value WHEN [compare_value] THEN result [WHEN [compare_value] THEN result ...] [ELSE result] END

SELECT * FROM table LEFT JOIN x ON x.id = table.id LEFT JOIN (SELECT id, CASE table.x WHEN 1 THEN "tablea" WHEN 2 THEN "tableb" WHEN 3 THEN "tablec" END FROM tablex) AS tmpe ON tmpe.id = table.n WHERE table.id = "hello" LIMIT 1;

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