case when分栏,不同情况查询不同的表
SELECT a.id,a.to_id,a.stateCASEWHEN a.state = 0 THEN (SELECT b.picture FROM B AS b WHERE a.to_id=b.id)WHEN a.state = 1 THEN (SELECT b.picture FROM B AS b WHERE a.to_id=b.id)END AS picture,CASEWHEN a.s
原创
2014-11-21 10:48:34 ·
7924 阅读 ·
0 评论