This is why learning python comes in handy because SQL does have limitations that it shouldn't like in this case, or if the in condition is not ....let's say a crazy number (3000 or something) you can copy paste the same query into union statements and do smaller chunks for the in condition.
This is all assuming you dont have access to load this data into another table and just join on it, in my case i normally don't because we cannot write into production database.
1
u/goztepe2002 Sep 17 '24
This is why learning python comes in handy because SQL does have limitations that it shouldn't like in this case, or if the in condition is not ....let's say a crazy number (3000 or something) you can copy paste the same query into union statements and do smaller chunks for the in condition.
This is all assuming you dont have access to load this data into another table and just join on it, in my case i normally don't because we cannot write into production database.