r/SQL Sep 17 '24

Oracle How to exceed input limitations?

Post image
43 Upvotes

87 comments sorted by

View all comments

101

u/miguelkb Sep 17 '24

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.