Add SQL IN command to Query
Add the IN command from SQL to the Aeries web Query
2
votes
Heather Benson
shared this idea
-
Ernest
commented
This would eliminate the need to have to build long strings of parenthetically grouped "OR" constraints.
For example, if we were interested in STU records for 5 specific students (numbered 1 through 5, in this contrived example)...
...rather than:
IF ( STU.ID = 1 OR STU.ID = 2 OR STU.ID = 3 OR STU.ID = 4 OR STU.ID = 5 )...we could use something along the lines of:
IF STU.ID IN (1, 2, 3, 4, 5)
