Combine two SELECT() expressions to form one?

Im trying to generate a type of account statement that has withdrawals and deposits listed in a table similar to a bank statement.

The withdrawals are in one table and the deposits are in another table.

How can i combine both SELECT() expressions  into one?

The main goal is to use this in a template via the  <<Start: SELECT() >> expression to create a PDF.

0 9 496
9 REPLIES 9
Top Labels in this Space