SELECT
s.id,s.name
,
case
s.class_id
when 1 THEN c1.name
when 2 THEN c2.name
ELSE c3.name
END as className
FROM
student s
LEFT JOIN class1 c1 on s.class_id=c1.id
LEFT JOIN class2 c2 on s.class_id=c2.id
LEFT JOIN class3 c3 on s.class_id=c3.id
mysql根据不同的查关联查询不同的表
最新推荐文章于 2024-05-14 17:07:48 发布