select designcode ,path,bh,id ,able from up_color as a where exists (select 1 from item as b where brandcode='01' and designcode = a.designcode) and a.path<>'' and a.able=1
select designcode ,path,bh,id ,able from up_color as a where exists ( select designcode from item where brandcode='01' and designcode = a.designcode) and a.path <> '' and a.able=1
select designcode from item
where brandcode='01' and designcode = a.designcode) and a.path <> '' and a.able=1