In my db2 database I have three tables.
This stores the relationship that each computer has multiple software items installed. So Computer_Software just has a foreign key to Computer and Software.
I need a query that returns for a given set of computers, the list of software which is installed on ALL of them.
So it would be something like this:
select id from software where computer_id = 1 intersect select id from software where computer_id = 2 intersect select id from software where computer_id = 5
But I need to supply the computer_ids in a list. Is there some kind of nested select type way I can do this?