search

beancount / beanquery

A customizable light-weight SQL query tool that works on tabular data, including Beancount.
GNU General Public License v2.0
19 stars 12 forks source link

Implement `JOIN`s #184

Open dnicolodi opened 3 months ago

dnicolodi commented 3 months ago

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;