help with a query

[oliver voegeli]

Hello

Given two tables:

Table Person:

ID | Age
--------
1  | 45
2  | 32
etc.

Table Answer (ID: Foreign-key which relates to the table Person, 1:n)

ID | QuestionNo | Answer
1  | 1          | 3
1  | 2          | 1
1  | 3          | 2
2  | 1          | 1
etc.

Let's say, each person fills out three questions. Now I would like to have a resultset in which each row represents a person, and each of the three questions (QuestionNo) gets a column of its own, in where you would find the given answer:

Age | Question1 | Question2 | Question3
45  | 3         | 1         | 2
32  | 1   etc.

How should the sql-statement look like?

Thx for any help!
Oliver