SELECT brand FROM `asset_typeAndBrand` where 1=1 and brand is not NULL and assetType = '相机'
从资产品牌表中查询品牌,将null去除
我这里添加了过滤条件,根据相机类型去查
SELECT brand FROM `asset_typeAndBrand` where 1=1 and brand is not NULL and assetType = '相机'
从资产品牌表中查询品牌,将null去除
我这里添加了过滤条件,根据相机类型去查