Timeline for using column in sub query within SELECT
Current License: CC BY-SA 4.0
3 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jul 25, 2021 at 20:28 | comment | added | Abecee |
Right now, I see renamed tables and an added column. This won't affect the outcome. Strictly speaking, there was no result set in the first place. (As a side note: In the old days, there was no explicit JOIN - it had to be done in the WHERE clause.) With the syntactically correct statement, there might be a non-empty result set. Whether it matches your intentions is hard to tell with no sample data and no expected outcome. Not sure how exactly to read the added "Users comments..." - but's not what I had guessed from the statement.
|
|
| Jul 25, 2021 at 8:49 | comment | added | Nir |
I made some adjustments to my question to make it clearer. Moving s.userId <> tdu.id won't result in different result set?
|
|
| Jul 23, 2021 at 19:10 | history | answered | Abecee | CC BY-SA 4.0 |