NamedQuery WHERE multiple values

Ignition
, ,
1

I'm trying to look up records by a column, but matching on multiple values.

The user enters a value that is bound to parameter1 that queryA selects records that match. Then queryB selects from another table where records match the values from one of the columns of queryA.

But that could have none or many values.

How would I accomplish a query that selected where it matched any of the values?

2

If you can run both queries at once, I would just use the WHERE IN operator with a nested query.

QueryB
WHERE col IN (QueryA);
3

I can. Let me try that out, thanks!

4

Also consider using an INNER JOIN. Many DB's will run those faster than any other multi-table operation.