You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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;
The text was updated successfully, but these errors were encountered:
JOIN
s would be very useful for creating more advanced reports.Example query:
The text was updated successfully, but these errors were encountered: