Timeline for MySQL Count(Table1.ColId) Where IN (any of Table2.Col1 ,Table2.Col2)
Current License: CC BY-SA 4.0
14 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jul 16, 2019 at 4:44 | answer | added | Akina | timeline score: 0 | |
| Jul 16, 2019 at 4:40 | comment | added | Akina | LEFT JOIN will NOT eject non-matched pairs!!! It can only increase the count when duplicates by joining condition exists in slave table. | |
| Jul 16, 2019 at 4:37 | history | edited | Akina | CC BY-SA 4.0 |
Code formatting
|
| Jul 15, 2019 at 19:31 | comment | added | mustaccio | Please consider reading this advice | |
| Jul 15, 2019 at 17:24 | history | edited | StixO | CC BY-SA 4.0 |
added 60 characters in body
|
| Jul 15, 2019 at 17:23 | comment | added | StixO | @RickJames too low. Exists ?? In Subquery ?? | |
| Jul 15, 2019 at 17:22 | comment | added | StixO | @mustaccio No I do not want inner joins . With that it combines the joins and the resulting count is 0, I want to get a count for Id where it exists in the other T2.Columns 1 through x .. | |
| Jul 15, 2019 at 17:18 | history | edited | StixO | CC BY-SA 4.0 |
added 256 characters in body
|
| Jul 15, 2019 at 17:15 | comment | added | mustaccio | You probably wanted inner joins, not outer. | |
| Jul 15, 2019 at 17:13 | comment | added | Rick James |
Make the col names consistent. Shorten the question to only 3 tables total. Shorten the column names. You say "not correct" -- too high? Too low? Are the tables 1:many? (or what)? Switch from LEFT JOIN to EXISTS?
|
|
| Jul 15, 2019 at 17:10 | comment | added | StixO | @RickJames Yes - I missed that .. | |
| Jul 15, 2019 at 17:10 | history | edited | StixO | CC BY-SA 4.0 |
added 6 characters in body
|
| Jul 15, 2019 at 17:09 | comment | added | Rick James |
What column is IN (...) ? Perhaps you mean T1.id IN (...)?
|
|
| Jul 15, 2019 at 17:04 | history | asked | StixO | CC BY-SA 4.0 |