Get Count from two individual tables with different status count
I have two tables in that I'm using two columns column1, column2
where column2 is contained different status id like 1, 2, 3, 4
now I need a query where users in column1 are compared with all the status present in column2 and get the count individually
and compare one particular status wheather it is greater than or equals to 10 and count for remaining status should be 0 for each particular user enter image description here
mysql mysql-workbench
edited Nov 20 '18 at 7:19
Dilip Borad
171417
asked Nov 20 '18 at 4:43
CazadorCazador
63
|
show 2 more comments
I have two tables in that I'm using two columns column1, column2
where column2 is contained different status id like 1, 2, 3, 4
now I need a query where users in column1 are compared with all the status present in column2 and get the count individually
and compare one particular status wheather it is greater than or equals to 10 and count for remaining status should be 0 for each particular user enter image description here
mysql mysql-workbench
edited Nov 20 '18 at 7:19
Dilip Borad
171417
asked Nov 20 '18 at 4:43
CazadorCazador
63
2
please provide sample data and expected output
– fa06
Nov 20 '18 at 4:44
Actually I'm trying to add the table but it is not working in this comment
– Cazador
Nov 20 '18 at 4:47
It would be great if you add this in your question
– fa06
Nov 20 '18 at 4:47
I've given you the example output
– Cazador
Nov 20 '18 at 5:26
Please refrain from using images/screenshots as a medium for code/data. See: stackoverflow.com/help/how-to-ask
– TrebuchetMS
Nov 20 '18 at 6:02
|
show 2 more comments
I have two tables in that I'm using two columns column1, column2
where column2 is contained different status id like 1, 2, 3, 4
now I need a query where users in column1 are compared with all the status present in column2 and get the count individually
and compare one particular status wheather it is greater than or equals to 10 and count for remaining status should be 0 for each particular user enter image description here
mysql mysql-workbench
edited Nov 20 '18 at 7:19
Dilip Borad
171417
asked Nov 20 '18 at 4:43
CazadorCazador
63
I have two tables in that I'm using two columns column1, column2
where column2 is contained different status id like 1, 2, 3, 4
now I need a query where users in column1 are compared with all the status present in column2 and get the count individually
and compare one particular status wheather it is greater than or equals to 10 and count for remaining status should be 0 for each particular user enter image description here
mysql mysql-workbench
mysql mysql-workbench
edited Nov 20 '18 at 7:19
Dilip Borad
171417
asked Nov 20 '18 at 4:43
CazadorCazador
63
edited Nov 20 '18 at 7:19
Dilip Borad
171417
asked Nov 20 '18 at 4:43
CazadorCazador
63
edited Nov 20 '18 at 7:19
Dilip Borad
171417
edited Nov 20 '18 at 7:19
Dilip Borad
171417
edited Nov 20 '18 at 7:19
Dilip Borad
171417
171417
asked Nov 20 '18 at 4:43
CazadorCazador
63
asked Nov 20 '18 at 4:43
CazadorCazador
63
asked Nov 20 '18 at 4:43
CazadorCazador
63
63
2
please provide sample data and expected output
– fa06
Nov 20 '18 at 4:44
Actually I'm trying to add the table but it is not working in this comment
– Cazador
Nov 20 '18 at 4:47
It would be great if you add this in your question
– fa06
Nov 20 '18 at 4:47
I've given you the example output
– Cazador
Nov 20 '18 at 5:26
Please refrain from using images/screenshots as a medium for code/data. See: stackoverflow.com/help/how-to-ask
– TrebuchetMS
Nov 20 '18 at 6:02
|
show 2 more comments
2
please provide sample data and expected output
– fa06
Nov 20 '18 at 4:44
Actually I'm trying to add the table but it is not working in this comment
– Cazador
Nov 20 '18 at 4:47
It would be great if you add this in your question
– fa06
Nov 20 '18 at 4:47
I've given you the example output
– Cazador
Nov 20 '18 at 5:26
Please refrain from using images/screenshots as a medium for code/data. See: stackoverflow.com/help/how-to-ask
– TrebuchetMS
Nov 20 '18 at 6:02
2
2
please provide sample data and expected output
– fa06
Nov 20 '18 at 4:44
please provide sample data and expected output
– fa06
Nov 20 '18 at 4:44
Actually I'm trying to add the table but it is not working in this comment
– Cazador
Nov 20 '18 at 4:47
Actually I'm trying to add the table but it is not working in this comment
– Cazador
Nov 20 '18 at 4:47
It would be great if you add this in your question
– fa06
Nov 20 '18 at 4:47
It would be great if you add this in your question
– fa06
Nov 20 '18 at 4:47
I've given you the example output
– Cazador
Nov 20 '18 at 5:26
I've given you the example output
– Cazador
Nov 20 '18 at 5:26
Please refrain from using images/screenshots as a medium for code/data. See: stackoverflow.com/help/how-to-ask
– TrebuchetMS
Nov 20 '18 at 6:02
Please refrain from using images/screenshots as a medium for code/data. See: stackoverflow.com/help/how-to-ask
– TrebuchetMS
Nov 20 '18 at 6:02
|
show 2 more comments
0
active
oldest
votes
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
});
}
});
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%2f53386367%2fget-count-from-two-individual-tables-with-different-status-count%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
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.
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%2f53386367%2fget-count-from-two-individual-tables-with-different-status-count%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
please provide sample data and expected output
– fa06
Nov 20 '18 at 4:44
Actually I'm trying to add the table but it is not working in this comment
– Cazador
Nov 20 '18 at 4:47
It would be great if you add this in your question
– fa06
Nov 20 '18 at 4:47
I've given you the example output
– Cazador
Nov 20 '18 at 5:26
Please refrain from using images/screenshots as a medium for code/data. See: stackoverflow.com/help/how-to-ask
– TrebuchetMS
Nov 20 '18 at 6:02