Timofey Lyzhenkov
Timofey Lyzhenkov
Solved with third query (using PostgreSQL): ``` php $incomes = (new Query())->select(['id', 'date', 'sum', 'currency_id'] )->from('incomes'); $expenses = (new Query())->select(['id', 'date', 'sum', 'currency_id'])->from('expenses'); $expenses->union($incomes, true)->orderBy(['date' => SORT_ASC]); $query = new...
jeesus, do you mean something like this? ``` php $incomes = (new Query())->select(['id', 'date', 'sum', 'currency_id', 'p.title project_title'] ) ->from('incomes') ->leftJoin('projects p', 'p.id = incomes.project_id'); $expenses = (new Query())->select(['id', 'date',...