In SQL, how can you select and match more than one column in a sub-select?

Here is the scenario:
In Oracle or MySQL, you want to select the rows return based on the condition of a sub select query. If this is just one column, it is no problem:

WHERE id IN (SELECT emp_id FROM promotion_list WHERE year = '2009');

However, the challenge is that if you want to match more than one column. How should the sql statement look like?