SQL Server 不同

Question

SELECT dbo.CLIENTREP.ref, dbo.REP2.ref
  FROM dbo.CLIENTREP 
  FULL OUTER JOIN dbo.REP2 ON (dbo.REP2.ref = dbo.CLIENTREP.ref)
    WHERE dbo.REP2.ref is null OR dbo.CLIENTREP.ref IS NULL;

如何指定仅返回 DISTINCT dbo.CLIENTREP.ref 和 dbo.REP2.ref ？

Answer 1

只需编写 SELECT DISTINCT ...

SELECT distinct dbo.CLIENTREP.ref, dbo.REP2.ref
FROM dbo.CLIENTREP 
FULL OUTER JOIN dbo.REP2 ON (dbo.REP2.ref = dbo.CLIENTREP.ref)
WHERE dbo.REP2.ref is null OR dbo.CLIENTREP.ref IS NULL;