Ok extremely dumb question SQL join of two tables, want to check intersection of rows simple join on two columns being equivalent: 180k rows select count(1) from table A where exists (two column equivalency in table B): 200k rows why why I want to go home
-
-
SQL, Mr. Van Buren, is trying to kill me, but I will kill it. -- Andrew Jackson
Show this thread -
Many days of Bothan processor time died to bring me this information
Show this thread -
-
Why the fuck don't left joins work You will JOIN when I tell you to!pic.twitter.com/wc2wQrg326
Show this thread -
I did it Think this should work Burning another week of CPU time to build the final table Cant wait to see my large ugly sonpic.twitter.com/jCzzo0h7c3
Show this thread
End of conversation
New conversation -
-
-
Why are you still working
-
gotta Secure the Bag
End of conversation
New conversation -
-
-
If you are doing it less for application development and more for reproducible reporting - I sometimes polish data from legacy databases using R. Consider https://dplyr.tidyverse.org/reference/join.html …
-
walled garden sadly :(
- Show replies
New conversation -
-
-
antijoin should be the name of a punk band
-
This Tweet is unavailable.
- Show replies
New conversation -
Loading seems to be taking a while.
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.