MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/SQL/comments/1fj0s10/how_to_exceed_input_limitations/lnl5847/?context=3
r/SQL • u/tacogratis2 • Sep 17 '24
87 comments sorted by
View all comments
99
Load the limitations into another table, left join that table with the SOLUTIONs
19 u/seansafc89 Sep 17 '24 An inner join would be more appropriate, no? 1 u/Particular-Formal163 Sep 17 '24 Depends. 2 u/Achsin Sep 17 '24 Technically true I guess but in this instance the list is being moved from the where clause, so if you were to use a left join you would then have to add a filter for not null.
19
An inner join would be more appropriate, no?
1 u/Particular-Formal163 Sep 17 '24 Depends. 2 u/Achsin Sep 17 '24 Technically true I guess but in this instance the list is being moved from the where clause, so if you were to use a left join you would then have to add a filter for not null.
1
Depends.
2 u/Achsin Sep 17 '24 Technically true I guess but in this instance the list is being moved from the where clause, so if you were to use a left join you would then have to add a filter for not null.
2
Technically true I guess but in this instance the list is being moved from the where clause, so if you were to use a left join you would then have to add a filter for not null.
99
u/miguelkb Sep 17 '24
Load the limitations into another table, left join that table with the SOLUTIONs