MYSQL 简单多表查询，需要大神门帮忙

Question

请各位大神帮忙。
要求：color表要遍历（不重复）
假如modal_id = 1 ,如果modal_color 表中存在 modal_1 ,对应status=1

Answer 1

看不太懂题目，所以就按自己的理解来了
select a.color_name, IF(c.id = 1,1,0) as status from color a LEFT JOIN modal_color b on a.id = b.color_id LEFT JOIN modal c on b.modal_id = c.id ORDER BY a.id;