First of all, your query looks OK.
Here is what i tested:
DECLARE @T1 TABLE ([Products] VARCHAR(30), [Area] VARCHAR(3), [Price] INT, [Finance] VARCHAR(5))
INSERT INTO @T1([Products], [Area], [Price], [Finance])
VALUES('Apple', '20', 500, 'BA'),
('Apple', '20', 200, 'LA'),
('Apple', '20', NULL, 'BA'),
('Orange', '10', 50, 'L6'),
('Kiwi', '31', 250, 'ZS'),
('Kiwi', '31', 150, 'BA'),
('Mango', '14', 25, 'F')
DECLARE @T2 TABLE ([Products] VARCHAR(30), [Area] VARCHAR(3), [Price] INT, [Finance] VARCHAR(5))
INSERT INTO @T2 ([Products], [Area], [Price], [Finance])
VALUES('Cherry', '02', 221, 'LB'),
('Cherry', '02', 551, 'LB'),
('Cherry', '02', 75, 'LA'),
('Apple', '20', 500, 'BA'),
('Blueberry', '15', 125, 'ZS'),
('Blueberry', '15', 135, 'F'),
('Kiwi', '31', 150, 'BA'),
('Kiwi', '31', 250, 'ZS'),
('Banana', '50', 255, 'L6'),
('Banana', '50', 355, 'L6'),
('Banana', '50', 121, 'BA'),
('Mango', '14', 25, 'F')
SELECT *
FROM (
SELECT *
FROM @T2
EXCEPT
SELECT *
FROM @T1
) AS T
ORDER BY T.Products DESC
Result:
Products Area Price Finance
Cherry 02 75 LA
Cherry 02 221 LB
Cherry 02 551 LB
Blueberry 15 125 ZS
Blueberry 15 135 F
Banana 50 121 BA
Banana 50 255 L6
Banana 50 355 L6
Returns exactly what you want.