DECLARE @Vanzari TABLE (C INT, S INT, A INT, L INT, Valoare INT)
INSERT INTO @Vanzari
VALUES (1,1,1,1,100), (1,2,1,1,200), (2,1,1,1,50)
DECLARE @Blocari TABLE (C INT, S INT, A INT, L INT, Valoare INT)
INSERT INTO @Blocari
VALUES (1,1,1,1,3), (2,3,1,1,2)
SELECT * FROM @Vanzari
SELECT * FROM @Blocari
SELECT COALESCE(V.C, B.C) AS C,
COALESCE(V.S, B.S) AS S,
COALESCE(V.A, B.A) AS A,
COALESCE(V.L, B.L) AS L,
COALESCE(V.Valoare,0) AS ValoareV,
COALESCE(B.Valoare,0) AS ValoareB
FROM @Vanzari AS V
FULL OUTER JOIN @Blocari AS B ON V.C = B.C
AND V.S = B.S
AND V.A = B.A
AND V.L = B.L