fxm1992(提问者)回复 孤陌 :select shop_name,case shop_type when \'ser\' THEN \'服务类店铺\' ELSE \'实物类店铺\' end AS \'店铺类型\' from sysshop_shop where shop_name=\'${shop_name}\' and shop_type=\'${shop_type}\' ,select shop_id,shop_name from sysshop_shop where shop_name =\'${shop_name}\'写这两个数据集你看对不