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;
Comment puis-je spécifier que seuls DISTINCT
dbo.CLIENTREP.ref
et dbo.REP2.ref
sont renvoyés?
Il suffit d'écrire 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;