导出上传文件已上传到附件
SELECT
x.ordersourceid 渠道ID,
x.ordersourcename 渠道名称,
y.country 渠道所在站点国家,
x.brand 品牌,
(CASE
x.isdefault
WHEN 1 THEN '是' ELSE '否'
END )
'是否默认'
FROM
Apx_Brand_Detail X
INNER JOIN Apx_Brand_OrderSource Y ON x.groupid = y.groupid
AND x.ordersourceid = y.ordersourceid
WHERE
x.ordersourceid NOT IN ( SELECT ordersourceid FROM Apx_Brand_Detail WHERE customerid = 1 AND id IN ( SELECT detailid FROM Apx_OrderSource_BrowseNode WHERE customerid = 1 ) GROUP BY ordersourceid, ordersourcename )
AND x.ordersourcename <> ''
