Mixing
Select sum condition join table mysql
1
I want to sum column "sisastock" in "tbpembelian" join with "tbproduk". but my result just one row.
My query :
select
pe.idprd, p.nmprd, sum(pe.sisastock) as 'totalsisastock',
pe.tglmasuk, k.idkat, d.iddvs
from
tbproduk as p
left join
tbpembelian as pe on pe.idprd = p.idprd
join
tbkategori as k on p.idkat = k.idkat
join
tbdivisi as d on p.iddvs = d.iddvs
having
sum(pe.sisastock) > 0
order by
pe.tglmasuk DESC
Table "tbproduk"
Table "tbpembelian"
The result I want
java mysql
edited Jan 4 at 18:20
marc_s
582k13011221268
asked Jan 2 at 5:29
Steven WiajiSteven Wiaji
227
add a comment |
1
I want to sum column "sisastock" in "tbpembelian" join with "tbproduk". but my result just one row.
My query :
select
pe.idprd, p.nmprd, sum(pe.sisastock) as 'totalsisastock',
pe.tglmasuk, k.idkat, d.iddvs
from
tbproduk as p
left join
tbpembelian as pe on pe.idprd = p.idprd
join
tbkategori as k on p.idkat = k.idkat
join
tbdivisi as d on p.iddvs = d.iddvs
having
sum(pe.sisastock) > 0
order by
pe.tglmasuk DESC
Table "tbproduk"
Table "tbpembelian"
The result I want
java mysql
edited Jan 4 at 18:20
marc_s
582k13011221268
asked Jan 2 at 5:29
Steven WiajiSteven Wiaji
227
2
you are missing group by clause
– Kandy
Jan 2 at 5:35
add a comment |
1
1
1
I want to sum column "sisastock" in "tbpembelian" join with "tbproduk". but my result just one row.
My query :
select
pe.idprd, p.nmprd, sum(pe.sisastock) as 'totalsisastock',
pe.tglmasuk, k.idkat, d.iddvs
from
tbproduk as p
left join
tbpembelian as pe on pe.idprd = p.idprd
join
tbkategori as k on p.idkat = k.idkat
join
tbdivisi as d on p.iddvs = d.iddvs
having
sum(pe.sisastock) > 0
order by
pe.tglmasuk DESC
Table "tbproduk"
Table "tbpembelian"
The result I want
java mysql
edited Jan 4 at 18:20
marc_s
582k13011221268
asked Jan 2 at 5:29
Steven WiajiSteven Wiaji
227
I want to sum column "sisastock" in "tbpembelian" join with "tbproduk". but my result just one row.
My query :
select
pe.idprd, p.nmprd, sum(pe.sisastock) as 'totalsisastock',
pe.tglmasuk, k.idkat, d.iddvs
from
tbproduk as p
left join
tbpembelian as pe on pe.idprd = p.idprd
join
tbkategori as k on p.idkat = k.idkat
join
tbdivisi as d on p.iddvs = d.iddvs
having
sum(pe.sisastock) > 0
order by
pe.tglmasuk DESC
Table "tbproduk"
Table "tbpembelian"
The result I want
java mysql
java mysql
edited Jan 4 at 18:20
marc_s
582k13011221268
asked Jan 2 at 5:29
Steven WiajiSteven Wiaji
227
edited Jan 4 at 18:20
marc_s
582k13011221268
asked Jan 2 at 5:29
Steven WiajiSteven Wiaji
227
edited Jan 4 at 18:20
marc_s
582k13011221268
edited Jan 4 at 18:20
marc_s
582k13011221268
edited Jan 4 at 18:20
marc_s
582k13011221268
582k13011221268
asked Jan 2 at 5:29
Steven WiajiSteven Wiaji
227
asked Jan 2 at 5:29
Steven WiajiSteven Wiaji
227
asked Jan 2 at 5:29
Steven WiajiSteven Wiaji
227
227
2
you are missing group by clause
– Kandy
Jan 2 at 5:35
add a comment |
2
you are missing group by clause
– Kandy
Jan 2 at 5:35
2
2
you are missing group by clause
– Kandy
Jan 2 at 5:35
you are missing group by clause
– Kandy
Jan 2 at 5:35
add a comment |
1 Answer
1
active
oldest
votes
1
Try This it may help, Because you have listed one column in your SQL SELECT statement that is not encapsulated in the SQL SUM function, you must use the SQL GROUP BY clause.
select pe.idprd, p.nmprd, pe.tglmasuk, k.idkat, d.iddvs, sum(pe.sisastock) as
'totalsisastock'
from tbproduk as p
left join tbpembelian as pe on pe.idprd = p.idprd
join tbkategori as k on p.idkat = k.idkat
join tbdivisi as d on p.iddvs = d.iddvs
group by pe.idprd, p.nmprd, pe.tglmasuk, k.idkat, d.iddvs
having sum(pe.sisastock) > 0
order by pe.tglmasuk DESC
answered Jan 2 at 5:40
KandyKandy
348414
kandy : thx for your help. but I found my answer in other question : dba.stackexchange.com/questions/186532/…
– Steven Wiaji
Jan 2 at 5:42
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54001637%2fselect-sum-condition-join-table-mysql%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
1
Try This it may help, Because you have listed one column in your SQL SELECT statement that is not encapsulated in the SQL SUM function, you must use the SQL GROUP BY clause.
select pe.idprd, p.nmprd, pe.tglmasuk, k.idkat, d.iddvs, sum(pe.sisastock) as
'totalsisastock'
from tbproduk as p
left join tbpembelian as pe on pe.idprd = p.idprd
join tbkategori as k on p.idkat = k.idkat
join tbdivisi as d on p.iddvs = d.iddvs
group by pe.idprd, p.nmprd, pe.tglmasuk, k.idkat, d.iddvs
having sum(pe.sisastock) > 0
order by pe.tglmasuk DESC
answered Jan 2 at 5:40
KandyKandy
348414
kandy : thx for your help. but I found my answer in other question : dba.stackexchange.com/questions/186532/…
– Steven Wiaji
Jan 2 at 5:42
add a comment |
1
Try This it may help, Because you have listed one column in your SQL SELECT statement that is not encapsulated in the SQL SUM function, you must use the SQL GROUP BY clause.
select pe.idprd, p.nmprd, pe.tglmasuk, k.idkat, d.iddvs, sum(pe.sisastock) as
'totalsisastock'
from tbproduk as p
left join tbpembelian as pe on pe.idprd = p.idprd
join tbkategori as k on p.idkat = k.idkat
join tbdivisi as d on p.iddvs = d.iddvs
group by pe.idprd, p.nmprd, pe.tglmasuk, k.idkat, d.iddvs
having sum(pe.sisastock) > 0
order by pe.tglmasuk DESC
answered Jan 2 at 5:40
KandyKandy
348414
kandy : thx for your help. but I found my answer in other question : dba.stackexchange.com/questions/186532/…
– Steven Wiaji
Jan 2 at 5:42
add a comment |
1
1
1
Try This it may help, Because you have listed one column in your SQL SELECT statement that is not encapsulated in the SQL SUM function, you must use the SQL GROUP BY clause.
select pe.idprd, p.nmprd, pe.tglmasuk, k.idkat, d.iddvs, sum(pe.sisastock) as
'totalsisastock'
from tbproduk as p
left join tbpembelian as pe on pe.idprd = p.idprd
join tbkategori as k on p.idkat = k.idkat
join tbdivisi as d on p.iddvs = d.iddvs
group by pe.idprd, p.nmprd, pe.tglmasuk, k.idkat, d.iddvs
having sum(pe.sisastock) > 0
order by pe.tglmasuk DESC
answered Jan 2 at 5:40
KandyKandy
348414
Try This it may help, Because you have listed one column in your SQL SELECT statement that is not encapsulated in the SQL SUM function, you must use the SQL GROUP BY clause.
select pe.idprd, p.nmprd, pe.tglmasuk, k.idkat, d.iddvs, sum(pe.sisastock) as
'totalsisastock'
from tbproduk as p
left join tbpembelian as pe on pe.idprd = p.idprd
join tbkategori as k on p.idkat = k.idkat
join tbdivisi as d on p.iddvs = d.iddvs
group by pe.idprd, p.nmprd, pe.tglmasuk, k.idkat, d.iddvs
having sum(pe.sisastock) > 0
order by pe.tglmasuk DESC
answered Jan 2 at 5:40
KandyKandy
348414
answered Jan 2 at 5:40
KandyKandy
348414
answered Jan 2 at 5:40
KandyKandy
348414
answered Jan 2 at 5:40
KandyKandy
348414
348414
kandy : thx for your help. but I found my answer in other question : dba.stackexchange.com/questions/186532/…
– Steven Wiaji
Jan 2 at 5:42
add a comment |
kandy : thx for your help. but I found my answer in other question : dba.stackexchange.com/questions/186532/…
– Steven Wiaji
Jan 2 at 5:42
kandy : thx for your help. but I found my answer in other question : dba.stackexchange.com/questions/186532/…
– Steven Wiaji
Jan 2 at 5:42
kandy : thx for your help. but I found my answer in other question : dba.stackexchange.com/questions/186532/…
– Steven Wiaji
Jan 2 at 5:42
add a comment |
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54001637%2fselect-sum-condition-join-table-mysql%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
2
you are missing group by clause
– Kandy
Jan 2 at 5:35