SQL select from two tables

SELECT
  rquirements.ID,
  offers.*
FROM
  requirements
  INNER JOIN offers ON requirements.AGE=offers.AGE
     AND requirements.GENDER=offers.GENDER

Cycles through all requirements. If you want hust a special requirement, add

WHERE rquirements.ID=<whatever>