我现在想实现若干张表完全连接,且某字段无值时显示空,怎么实现?
------解决思路----------------------
ISNULL(COLNAME, '') AS COLNAME
------解决思路----------------------
SELECT *
FROM T1
FULL OUTER JOIN T2 ON T1.ID = T2.ID
FULL OUTER JOIN T3 ON T1.ID = T3.ID
ISNULL(COLNAME, '') AS COLNAME
SELECT *
FROM T1
FULL OUTER JOIN T2 ON T1.ID = T2.ID
FULL OUTER JOIN T3 ON T1.ID = T3.ID