你有了 model_color 表,所以对于你要求的结果,model 已经不需要用了 例:create temporary table color select 1 as id, '红' as color union select 2, '蓝' union select 3, '绿';create temporary table model_color select 2 as color_id, 2 as model_id;select color, if(isnull(model_id),0,1) as status from color left join model_color on color.id=model_color.color_id color status 红 0 蓝 1 绿 0
例:create temporary table color
select 1 as id, '红' as color
union select 2, '蓝'
union select 3, '绿';create temporary table model_color
select 2 as color_id, 2 as model_id;select color, if(isnull(model_id),0,1) as status from color left join model_color on color.id=model_color.color_id
color status
红 0
蓝 1
绿 0
1、贴出你的create table ... 语句 和一些测试数据
2、贴出最后结果是什么样的,并且说明一下业务逻辑。