select TABLE1.* FROM TABLE1 WHERE ID_FLD IN ( select TABLE2.ID_FLD FROM TABLE2 WHERE ...)
>select TABLE1.* FROM TABLE1 WHERE ID_FLD IN (select TABLE2.ID_FLD, SUM( > TABLE2.QUANTITY) as USED_QUANTITY FROM TABLE2 GROUP BY TABLE2.ID_FLD) >