货架等色查询

SELECT TOP 10000 a.BIN,a.COLOR,b.name as 颜色 FROM [dbo].[mms_aibins] a
left join [dbo].[mms_aibin_lightcolor]  b on b.color=a.color
where a.BIN like 'SMC007%'
order by a.BIN