select o.card_no
	,o.ref_no
	,o.tran_val

from OriginalErrorFiles  o

where  exists (select h.card_no
			,h.ref_no
			,h.tran_val
		from  hopefullyworks2 h
		where( h.card_no = o.card_no and 
		      h.ref_no=o.ref_no and
			h.tran_val = o.tran_val
			))

e.g Original
card_no   ref_no    tran_value
12        20        12.00
12        20        2.00
47        01        4.00
52        11        2.00
04        05        13.00
04        20        6.00

e.g Posted
card_no    ref_no    tran_value
12         20        12.00
12         21         2.00
47         01         4.00
52         25         25.00
04         20         6.00

e.g Result
card_no     ref_no    tran_value
12        20        2.00
52        11        2.00
04        05        13.00

DECLARE @original table (card_no tinyint, ref_no tinyint, tran_value decimal(4,2))

INSERT INTO @original VALUES(12,20,12.00)
INSERT INTO @original VALUES(12,20,2.00)
INSERT INTO @original VALUES(47,1,4.00)
INSERT INTO @original VALUES(52,11,2.00)
INSERT INTO @original VALUES(4,5,13.00)
INSERT INTO @original VALUES(4,20,6.00)

DECLARE @posted table (card_no tinyint, ref_no tinyint, tran_value decimal(4,2))

INSERT INTO @posted VALUES(12,20,12.00)
INSERT INTO @posted VALUES(12,21,2.00)
INSERT INTO @posted VALUES(47,1,4.00)
INSERT INTO @posted VALUES(52,25,25.00)
INSERT INTO @posted VALUES(4,20,6.00)

SELECT * 
FROM @original o
WHERE NOT EXISTS 
	(SELECT * FROM @posted p WHERE o.card_no = p.card_no AND o.ref_no = p.ref_no AND o.tran_value = p.tran_value)