Timeline for Complicated query that compares subselects
Current License: CC BY-SA 4.0
11 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 2, 2023 at 18:53 | comment | added | Kamil | I got the idea about removing "outer" select, however it is there beacause I was thinking forward. I want to join all these results with something else. | |
| Mar 2, 2023 at 18:20 | comment | added | Rick James | Thanks, @AndriyM -- I was being quite blind. | |
| Mar 2, 2023 at 18:18 | history | edited | Rick James | CC BY-SA 4.0 |
rewrite query
|
| Mar 2, 2023 at 8:59 | comment | added | Andriy M |
The queries in the last two code blocks. You have SELECT ... FROM ... WHERE ... RIGHT JOIN ... WHERE ... ON ... WHERE ... there. That doesn't look right.
|
|
| Mar 2, 2023 at 5:46 | comment | added | Rick James | @AndriyM - Which query are you saying has a syntax problem? | |
| Mar 1, 2023 at 23:13 | comment | added | Andriy M |
The idea is clear (more or less) but the syntax is wrong. A join can't follow the WHERE clause. Nor can you have more than one WHERE per SELECT (at the same level, that is).
|
|
| Mar 1, 2023 at 18:00 | comment | added | Kamil |
RIGHT JOIN after where e.x in (39, 40)?
|
|
| Mar 1, 2023 at 2:58 | comment | added | Rick James | I added some more. | |
| Mar 1, 2023 at 2:58 | history | edited | Rick James | CC BY-SA 4.0 |
added 891 characters in body
|
| Mar 1, 2023 at 1:18 | comment | added | Kamil |
Yes, I need to find differences. Items that are in both "item groups" are not important. But these are not tables. It is the same table, just different "item group" id's. Regarding extra layer - I'm using it for "where ... is null". How can I take only differences without that SELECT * FROM () where ... is null around my subquery that does right join?
|
|
| Feb 28, 2023 at 16:27 | history | answered | Rick James | CC BY-SA 4.0 |