multiple groups of query in 1 statement using OR
0
I am trying to identify low "scores" added to a table where other scores are high. Put simply, I want to know where someone has scored 1 for a single question but 2 or above for the others. I came up with this;
SELECT * FROM `review_survey`, `users` WHERE review_survey.user_id =users.kituser_id AND
(review_survey.s1 < 2 AND review_survey.s2 >= 2 AND review_survey.s3 >= 2 )
OR (safeguard_review_survey.s1 >= 2 AND safeguard_review_survey.s2 < 2
AND safeguard_review_survey.s3 >= 2) AND `complete` = 1 AND users.account = 1
But it returns a massive dataset that can't possibly be accurate.
Where do I start?
mysql
asked Nov 14 '18 at 10:40
Sean in NZSean in NZ
62
add a comment |
0
I am trying to identify low "scores" added to a table where other scores are high. Put simply, I want to know where someone has scored 1 for a single question but 2 or above for the others. I came up with this;
SELECT * FROM `review_survey`, `users` WHERE review_survey.user_id =users.kituser_id AND
(review_survey.s1 < 2 AND review_survey.s2 >= 2 AND review_survey.s3 >= 2 )
OR (safeguard_review_survey.s1 >= 2 AND safeguard_review_survey.s2 < 2
AND safeguard_review_survey.s3 >= 2) AND `complete` = 1 AND users.account = 1
But it returns a massive dataset that can't possibly be accurate.
Where do I start?
mysql
asked Nov 14 '18 at 10:40
Sean in NZSean in NZ
62
a good start would be using GROUP BY
– Harly H.
Nov 14 '18 at 10:46
You should start with providing sample data and the desired result set.
– fancyPants
Nov 14 '18 at 10:47
Welcome to Stack Overflow! Please provide a relevant and minimal sample data showcasing your requirements, and expected output. Refer this link on how to frame a good SQL question: Why should I provide an MCVE for what seems to me to be a very simple SQL query?
– Madhur Bhaiya
Nov 14 '18 at 10:51
add a comment |
0
0
0
I am trying to identify low "scores" added to a table where other scores are high. Put simply, I want to know where someone has scored 1 for a single question but 2 or above for the others. I came up with this;
SELECT * FROM `review_survey`, `users` WHERE review_survey.user_id =users.kituser_id AND
(review_survey.s1 < 2 AND review_survey.s2 >= 2 AND review_survey.s3 >= 2 )
OR (safeguard_review_survey.s1 >= 2 AND safeguard_review_survey.s2 < 2
AND safeguard_review_survey.s3 >= 2) AND `complete` = 1 AND users.account = 1
But it returns a massive dataset that can't possibly be accurate.
Where do I start?
mysql
asked Nov 14 '18 at 10:40
Sean in NZSean in NZ
62
I am trying to identify low "scores" added to a table where other scores are high. Put simply, I want to know where someone has scored 1 for a single question but 2 or above for the others. I came up with this;
SELECT * FROM `review_survey`, `users` WHERE review_survey.user_id =users.kituser_id AND
(review_survey.s1 < 2 AND review_survey.s2 >= 2 AND review_survey.s3 >= 2 )
OR (safeguard_review_survey.s1 >= 2 AND safeguard_review_survey.s2 < 2
AND safeguard_review_survey.s3 >= 2) AND `complete` = 1 AND users.account = 1
But it returns a massive dataset that can't possibly be accurate.
Where do I start?
mysql
mysql
asked Nov 14 '18 at 10:40
Sean in NZSean in NZ
62
asked Nov 14 '18 at 10:40
Sean in NZSean in NZ
62
asked Nov 14 '18 at 10:40
Sean in NZSean in NZ
62
asked Nov 14 '18 at 10:40
Sean in NZSean in NZ
62
asked Nov 14 '18 at 10:40
Sean in NZSean in NZ
62
62
a good start would be using GROUP BY
– Harly H.
Nov 14 '18 at 10:46
You should start with providing sample data and the desired result set.
– fancyPants
Nov 14 '18 at 10:47
Welcome to Stack Overflow! Please provide a relevant and minimal sample data showcasing your requirements, and expected output. Refer this link on how to frame a good SQL question: Why should I provide an MCVE for what seems to me to be a very simple SQL query?
– Madhur Bhaiya
Nov 14 '18 at 10:51
add a comment |
a good start would be using GROUP BY
– Harly H.
Nov 14 '18 at 10:46
You should start with providing sample data and the desired result set.
– fancyPants
Nov 14 '18 at 10:47
Welcome to Stack Overflow! Please provide a relevant and minimal sample data showcasing your requirements, and expected output. Refer this link on how to frame a good SQL question: Why should I provide an MCVE for what seems to me to be a very simple SQL query?
– Madhur Bhaiya
Nov 14 '18 at 10:51
a good start would be using GROUP BY
– Harly H.
Nov 14 '18 at 10:46
a good start would be using GROUP BY
– Harly H.
Nov 14 '18 at 10:46
You should start with providing sample data and the desired result set.
– fancyPants
Nov 14 '18 at 10:47
You should start with providing sample data and the desired result set.
– fancyPants
Nov 14 '18 at 10:47
Welcome to Stack Overflow! Please provide a relevant and minimal sample data showcasing your requirements, and expected output. Refer this link on how to frame a good SQL question: Why should I provide an MCVE for what seems to me to be a very simple SQL query?
– Madhur Bhaiya
Nov 14 '18 at 10:51
Welcome to Stack Overflow! Please provide a relevant and minimal sample data showcasing your requirements, and expected output. Refer this link on how to frame a good SQL question: Why should I provide an MCVE for what seems to me to be a very simple SQL query?
– Madhur Bhaiya
Nov 14 '18 at 10:51
add a comment |
1 Answer
1
active
oldest
votes
0
To begin wiht, please try this first:
SELECT * FROM
`review_survey`, `users`
WHERE
review_survey.user_id =users.kituser_id
AND ( --<-- missing parenthesis
(review_survey.s1 < 2 AND review_survey.s2 >= 2 AND review_survey.s3 >= 2 )
OR
(safeguard_review_survey.s1 >= 2 AND safeguard_review_survey.s2 < 2 AND safeguard_review_survey.s3 >= 2)
) --<-- missing parenthesis
AND `complete` = 1 AND users.account = 1
Better yet, move things around so you have
condition AND condition2 AND condition3 AND ( condition4 OR condition5)
As of now it's very likely AND and OR don't work as you'd expect
answered Nov 14 '18 at 10:51
Harly H.Harly H.
44527
sorry, made an error. fixed now. reload
– Harly H.
Nov 14 '18 at 10:52
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%2f53298258%2fmultiple-groups-of-query-in-1-statement-using-or%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
0
To begin wiht, please try this first:
SELECT * FROM
`review_survey`, `users`
WHERE
review_survey.user_id =users.kituser_id
AND ( --<-- missing parenthesis
(review_survey.s1 < 2 AND review_survey.s2 >= 2 AND review_survey.s3 >= 2 )
OR
(safeguard_review_survey.s1 >= 2 AND safeguard_review_survey.s2 < 2 AND safeguard_review_survey.s3 >= 2)
) --<-- missing parenthesis
AND `complete` = 1 AND users.account = 1
Better yet, move things around so you have
condition AND condition2 AND condition3 AND ( condition4 OR condition5)
As of now it's very likely AND and OR don't work as you'd expect
answered Nov 14 '18 at 10:51
Harly H.Harly H.
44527
sorry, made an error. fixed now. reload
– Harly H.
Nov 14 '18 at 10:52
add a comment |
0
To begin wiht, please try this first:
SELECT * FROM
`review_survey`, `users`
WHERE
review_survey.user_id =users.kituser_id
AND ( --<-- missing parenthesis
(review_survey.s1 < 2 AND review_survey.s2 >= 2 AND review_survey.s3 >= 2 )
OR
(safeguard_review_survey.s1 >= 2 AND safeguard_review_survey.s2 < 2 AND safeguard_review_survey.s3 >= 2)
) --<-- missing parenthesis
AND `complete` = 1 AND users.account = 1
Better yet, move things around so you have
condition AND condition2 AND condition3 AND ( condition4 OR condition5)
As of now it's very likely AND and OR don't work as you'd expect
answered Nov 14 '18 at 10:51
Harly H.Harly H.
44527
sorry, made an error. fixed now. reload
– Harly H.
Nov 14 '18 at 10:52
add a comment |
0
0
0
To begin wiht, please try this first:
SELECT * FROM
`review_survey`, `users`
WHERE
review_survey.user_id =users.kituser_id
AND ( --<-- missing parenthesis
(review_survey.s1 < 2 AND review_survey.s2 >= 2 AND review_survey.s3 >= 2 )
OR
(safeguard_review_survey.s1 >= 2 AND safeguard_review_survey.s2 < 2 AND safeguard_review_survey.s3 >= 2)
) --<-- missing parenthesis
AND `complete` = 1 AND users.account = 1
Better yet, move things around so you have
condition AND condition2 AND condition3 AND ( condition4 OR condition5)
As of now it's very likely AND and OR don't work as you'd expect
answered Nov 14 '18 at 10:51
Harly H.Harly H.
44527
To begin wiht, please try this first:
SELECT * FROM
`review_survey`, `users`
WHERE
review_survey.user_id =users.kituser_id
AND ( --<-- missing parenthesis
(review_survey.s1 < 2 AND review_survey.s2 >= 2 AND review_survey.s3 >= 2 )
OR
(safeguard_review_survey.s1 >= 2 AND safeguard_review_survey.s2 < 2 AND safeguard_review_survey.s3 >= 2)
) --<-- missing parenthesis
AND `complete` = 1 AND users.account = 1
Better yet, move things around so you have
condition AND condition2 AND condition3 AND ( condition4 OR condition5)
As of now it's very likely AND and OR don't work as you'd expect
answered Nov 14 '18 at 10:51
Harly H.Harly H.
44527
answered Nov 14 '18 at 10:51
Harly H.Harly H.
44527
answered Nov 14 '18 at 10:51
Harly H.Harly H.
44527
answered Nov 14 '18 at 10:51
Harly H.Harly H.
44527
44527
sorry, made an error. fixed now. reload
– Harly H.
Nov 14 '18 at 10:52
add a comment |
sorry, made an error. fixed now. reload
– Harly H.
Nov 14 '18 at 10:52
sorry, made an error. fixed now. reload
– Harly H.
Nov 14 '18 at 10:52
sorry, made an error. fixed now. reload
– Harly H.
Nov 14 '18 at 10:52
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%2f53298258%2fmultiple-groups-of-query-in-1-statement-using-or%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
a good start would be using GROUP BY
– Harly H.
Nov 14 '18 at 10:46
You should start with providing sample data and the desired result set.
– fancyPants
Nov 14 '18 at 10:47
Welcome to Stack Overflow! Please provide a relevant and minimal sample data showcasing your requirements, and expected output. Refer this link on how to frame a good SQL question: Why should I provide an MCVE for what seems to me to be a very simple SQL query?
– Madhur Bhaiya
Nov 14 '18 at 10:51