« first day (2876 days earlier)   

12:09 AM
so
I'm grabbing a bunch of records from a table and there's a condition where I have something like WHERE X=Y
and that only returns 11000 records
as expected
but then I'm grabbing a bunch of records from another table joined on this table where I use WHERE X!=y and that condition is getting rid of a ton of records
much more than 11000 records
which kind of baffles me -.-
 
Is your join too big/too little?
 
Then if I create a different query that just pulls those 11,000 records into a temp table, merge the temp table with all them joins and find the rows where the temp table's ID "is null" I get the right result again...
 

« first day (2876 days earlier)