I have one table that shows all transactions with fields, chequeNum and accTransaction. It'll look something like this but a thousand more entries.
**chequeNum accTransaction** withdrawal withdrawal withdrawal 1 2 3 withdrawal
The second table is a table with only cheque transactions and the fields, chequeNum and accTransaction
**chequeNum accTransaction** 3 John Deposit 2 Jane Deposit 1 Bob Deposit
The final outcome I want is:
**chequeNum accTransaction** withdrawal withdrawal withdrawal 1 Bob Deposit 2 Jane Deposit 3 John Deposit
Ultimately, i want to combine the two tables without altering the position of the transactions. There may also be instances where there isn't a cheque number in the table containing all cheque transactions to match the cheque number in the first table containing all transactions.