Welcome Guest, Not a member yet? Register   Sign In
how to write this sql with active record
#1

Hello everyone, I'm trying to calculate profit from two tables province_income and province_expenses. But I'm getting difficult to organize sql statement with ci4 query methods to make it work.
Help please, Thanks.

here is my sql

PHP Code:
                SELECT DateSUM(Income) as IncomeSUM(Expense) as ExpenseSUM(Income) - SUM(Expense) as Profit 
                FROM 

                          SELECT province_income.date as Dateprovince_income.amount as Incomeas Expense 
                          FROM province_income
                          LEFT JOIN province ON province
.provId province_income.provId WHERE province_income.provId
                          UNION ALL 
                          SELECT province_expenses
.date as Dateas Incomeprovince_expenses.amount as Expense 
                          FROM province_expenses
                          LEFT JOIN province ON province
.provId province_expenses.provId WHERE province_expenses.provId 
                   
) as 
                GROUP BY Date 
Reply


Messages In This Thread
how to write this sql with active record - by venance - 03-18-2021, 01:47 AM



Theme © iAndrew 2016 - Forum software by © MyBB