Qurey Showing All The Rows In Table

Hi guys,

The below query should produce all those customers who are in 'orginalerrorfiles' but not in 'hopefullyworks2'. 3 fields will be used as the check to make sure that the rows, that r identical won't be displayed but those that r different will be displayed.

Instead of doing that it just display everything in the table called 'orginalerrorfiles'.

Note 'orginalerrorfiles' consist of 141455 rows
'hopefullyworks2' consist of 134784 rows


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
))