Cacher is the code snippet organizer for pro developers

#left join ($1 as key, $2 & $3 as the column to fill the data)
join -t"," -j1 3 -j2 1 -a 1 -o 1.1,1.2,1.3,1.4,1.5,1.6,1.7,2.2,2.3 Prepaid_Payu_Zero_Charge.Zero.Sort PritSuspect.Data.Sort >> Prepaid_Payu_Zero_Charge_201801.JoinPrit

#inner join ($1 as key, $2 & $3 as the column to fill the data)
join -t"," -j1 3 -j2 1 -o 1.1,1.2,1.3,1.4,1.5,1.6,1.7,2.2,2.3 Prepaid_Payu_Zero_Charge.Zero.Sort PritSuspect.Data.Sort >> Prepaid_Payu_Zero_Charge_201801.JoinPrit

#left outer join
join -t"," -j1 3 -j2 1 -v1 -o 1.1,1.2,1.3,1.4,1.5,1.6,1.7,2.2,2.3 Prepaid_Payu_Zero_Charge.Zero.Sort PritSuspect.Data.Sort >> Prepaid_Payu_Zero_Charge_201801.JoinPrit