The ANSI SQL function ... in (select destype from proclib.delay where march.Flight=delay.Flight); The subquery resolves by substituting every value for MARCH.Flight into the subquery's WHERE clause, ...