SELECT * FROM ACCOUNT.TRANS WHERE ACCOUNT_ACCNO=1234567890 AND TXPHLDR='HumanLife Insurance Ltd' | ... | TXTYPE | ... | TXPBANK | TXPACCNO | TXHLDR | MANDATE | PURPOSE | EXECDATE | ... ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ 1 | ... | debit | ... | ZECBDEFF001 | 2375687253 | HumanLife Insurance Ltd | health insurance #98317573 | NULL | NULL | ... 2 | ... | transferal | ... | ZECBDEFF001 | 2375687254 | HumanLife Insurance Ltd | NULL | back pay, bill #81739616136 | 2015-01-13 | ... 3 | ... | debit | ... | ZECBDEFF001 | 2375687257 | HumanLife Insurance Ltd | accident insurance #38248713 | NULL | NULL | ... 4 | ... | debit | ... | ZECBDEFF001 | 2375687253 | HumanLife Insurance Ltd | health insurance #98317573 | NULL | NULL | ... 5 | ... | credit | ... | ZECBDEFF001 | 2375687251 | HumanLife Insurance Ltd | NULL | refund, doctor's bill #134916575 | NULL | ... 6 | ... | transferal | ... | ZECBDEFF001 | 2375687254 | HumanLife Insurance Ltd | NULL | life insurance #4232582, initial payment | | ... '...' marks values that are not relevant for this example