mysql - SELECT & Calculate SQL but answer wrong -

-

i want select data mysql. , wanted calculation @ query excution time. had 2 sql tables:

loan table :

loan_id|customer_name|total_amount 1000   |sashika      |55000 1001   |amell        |11000

settlement table :

sett_id|loan_id|amount a123    |1000    |1000 b123    |1001    |2000

thats how 2 tables like. want due value of loans. used below code generate wont' show correct values.

select loan.loan_id,loan.customer_name,loan.total_amount,sum(settlement.amount) 'total received',       ((loan.total_amount)-sum(settlement.amount ))as 'total due' loan , settlement loan.loan_id = 1001;

this code value of total(column) of settelement table. when try loan id(where loan_id=) amount of total of settlement value show , calculate. isn't value want. please me guys

loan_id| customer_name|total_amount|total_received|total_due 1000       |sashika       |55000       |1000          |54000

this how want edit question , make more understandable :)

you should use inner join , group 

select      loan.loan_id    ,loan.customer_name    ,loan.total_amount    ,sum(settlement.amount) 'total received'    ,((loan.total_amount)-sum(settlement.amount ))as 'total due'  loan  inner join settlement  on  loan.loan_id =  settlement.loan_id loan.loan_id=1001 group load.loan_id

Comments

Post a Comment

Popular posts from this blog

sequelize.js - Sequelize group by with association includes id -

-
so when requesting group sequelize follows: return models.workingcalendar .findall({ attributes: [ 'workingcalendar.periodid', 'workingcalendar.date', 'period.name' ], include: [ { model: models.period, attributes: [] } ], where: { getsudoid: currentgetsudo.id, unitplantid: unitplantid }, group: ['workingcalendar.periodid', 'workingcalendar.date', 'period.name'], }); sequelize run query: select [workingcalendar].[id], [workingcalendar].[periodid], [workingcalendar].[date], [period].[name] [workingcalendars] [workingcalendar] left outer join [periods] [period] on [wor...
Read more

java - Android raising EPERM (Operation not permitted) when attempting to send UDP packet after network connection -

-
when responding supplicant_state_changed_action broadcast , attempting send udp packet, exception: java.net.socketexception: sendto failed: eperm (operation not permitted) @ libcore.io.iobridge.maybethrowaftersendto(iobridge.java:542) @ libcore.io.iobridge.sendto(iobridge.java:511) @ java.net.plaindatagramsocketimpl.send(plaindatagramsocketimpl.java:184) @ java.net.datagramsocket.send(datagramsocket.java:305) @ com.mycompany.app.serviceclass.discover(serviceclass.java:355)at com.mycompany.app.serviceclass.access$600(serviceclass.java:39) @ com.mycompany.app.serviceclass$statemachine.run(serviceclass.java:242) @ java.lang.thread.run(thread.java:818) caused by: android.system.errnoexception: sendto failed: eperm (operation not permitted) @ libcore.io.posix.sendtobytes(native method) @ libcore.io.posix.sendto(posix.java:211) @ libcore.io.blockguardos.sendto(blockguardos.java:278) @ libcore.io.iobridge.sendto(iobridge.java:509) @ java.net.plaindat...
Read more

c++ - Migration from QScriptEngine to QJSEngine -

-
i'm migrating qscriptengine code on qjsengine. now, have: class pars { public: static qscriptvalue printmainlog(qscriptcontext* c, qscriptengine* e); }; qscriptvalue pars::printmainlog(qscriptcontext* c, qscriptengine* e) { //some actions return e->globalobject().property(""); } ... qscriptengine engine; ... engine.globalobject().setproperty("printlog",engine.newfunction(pars::printmainlog)); so, user can put printlog("what ever"); in application in , example, qlineedit , function pars::printmainlog evalute. is there way qjsengine? so, user put same printlog("what ever");? way find here , user should put logger.printlog("what ever"); logger class inherited qobject printlog slot.
Read more