First create the replica of Key field in both table and after joining load it resident and create a flag as if(Order_Key=Payment_Key,'Paid','Unpaid') as Flag.
Key As Order_Key,
Key AS Payment_Key,
If(Order_Key=Payment_Key,'Paid','Unpaid') as Flag
Drop Table Table;
Drop Field Order_Key,Payment_Key;
Hope this will help