Timeline for Select row from one query where opposites are not present in second query
Current License: CC BY-SA 3.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 8, 2015 at 0:16 | comment | added | Just Lucky Really | I'll put what I did as an answer, so that you can see ... Again, I think it's because I have simplified my tables, and my explanation is not clear Lol ... | |
| Mar 8, 2015 at 0:06 | comment | added | Rick James |
Keep in mind that [NOT] IN ( SELECT ... ) is inefficient. You explained it well enough for me to figure out what you wanted.
|
|
| Mar 7, 2015 at 23:56 | comment | added | Just Lucky Really |
Thanks, your answer got my brain working a little, and managed to get it working using NOT IN rather than NOT EXISTS. I wont post the full results, because I still don't think my question actually makes sense Lol ... I'll probably delete this question tomorrow, just wanted to say thanks for your time :D
|
|
| Mar 7, 2015 at 22:20 | history | answered | Rick James | CC BY-SA 3.0 |