This is the actual bottle neck in the above puzzle

If i want to select  antim_id from following table using query Q1...which has all the missile_id values returned by another query Q2 .

For eg. if Q2 returns 100,300,400

my Q1 should return 3000...How to do it.? Will using ALL will help?

DEFUSE_CAPABILITY

+----------+------------+

| antim_id | missile_id |

+----------+------------+

|     1000 |        100 |

|     1000 |        200 |

|     2000 |        100 |

|     2000 |        200 |

|     2000 |        300 |

|     3000 |        100 |

|     3000 |        200 |

|     3000 |        300 |

|     3000 |        400 |

|     3000 |        500 |

+----------+------------+