I believe you want a left join to include all records from SNTran but only matching records from RMARcpt. Then you’ll probably want to further provide other criteria so you do not see every single SNTran row. Perhaps only allow SN tran types of RMA-Entry and then those to customer such as Stk-Cus, Pur-Cus and Mfg-Cus transactions.