Welcome Guest, Not a member yet? Register   Sign In
active record error
#2

I'm not sure this is correct or not.
https://sql-to-ci-builder.herokuapp.com/

Code:
$this->db->select('motorvehicletyperevenuepointchrage.IncomeTypeID,motorvehicletyperevenuepointchrage.FeesID,motorvehicletyperevenuepointchrage.ChargeID,motorvehicletyperevenuepointchrage.AgencyID,motorvehicletyperevenuepointchrage.RevenuePointID,motorvehicle.MotorVehicleTypeEntryID,motorvehiclecharge.Description,motorvehiclecharge.AccountNumber,officeunitbookaccount.OfficeUnitID')
->from('motorvehicle')
->join('motorvehicletyperevenuepointchrage', 'motorvehicle.MotorVehicleTypeEntryID = motorvehicletyperevenuepointchrage.MotorVehicleTypeEntryID')
->join('motorvehiclecharge', 'motorvehicletyperevenuepointchrage.ChargeID = motorvehiclecharge.ChargeID')
->join('officeunitbookaccount', 'motorvehiclecharge.AccountNumber = officeunitbookaccount.AccountNumber')
->where('motorvehicle.MotorVehicleTypeEntryID', 'motorvehicletyperevenuepointchrage.MotorVehicleTypeEntryID', FALSE)
->where('motorvehicle.AgencyID', 'motorvehicletyperevenuepointchrage.AgencyID', FALSE)
->where('motorvehicle.RevenuePointID', 'motorvehicletyperevenuepointchrage.RevenuePointID', FALSE)
->where('motorvehicle.UVN', '1901/1907-04946')
->get();
Reply


Messages In This Thread
active record error - by JKIRUMBA - 09-25-2021, 05:24 PM
RE: active record error - by kenjis - 09-26-2021, 11:23 PM



Theme © iAndrew 2016 - Forum software by © MyBB