PL/SQL: Selecting multiple values from the same column
You can reference the same table multiple times in your query with an alias to solve this issue.
For example:
SELECT ref.row_id, f.word as fruit, v.word as vehicle
  FROM Rows ref INNER JOIN Words f ON ref.fruit_id = f.id
                INNER JOIN Words v ON ref.vehicle_id = v.id
 WHERE f.id = :PRODUKTART_ID
   and v.id = :VEHICLE_ID