beanquery icon indicating copy to clipboard operation
beanquery copied to clipboard

Implement `JOIN`s

Open dnicolodi opened this issue 1 year ago • 0 comments
trafficstars

JOINs would be very useful for creating more advanced reports.

Example query:

       SELECT account, bal1, bal2 FROM
         (SELECT account, sum(cost(position)) as bal1
          FROM CLOSE ON 2014-01-01 CLEAR)
         JOIN
         (SELECT account, sum(cost(position)) as bal2
          FROM CLOSE ON 2015-01-01 CLEAR)
         ON account;

dnicolodi avatar Jun 15 '24 23:06 dnicolodi