It looks like you have extra parenthesis in your subquery

try this instead

select (ordernum,date ) from table_name A where (order_num,date) in (Select order_num,date from table_name B)