Inner Join question

[ivan haentjens]

I'm having some problems writing a query for two joined tables:

Table 'persons':

- PersonId (PK)
- PersonFirstName
- PersonLastName

Table 'hobbies'

- HobbyId (PK)
- PersonId (FK)
- HobbyDescription

Now, let's say person 'John Doe' has several hobbies
like chess, walking, jogging ...

I want to select all persons with last name 'Doe' and
hobbies chess AND walking.

It's the combination of the two hobbies that's giving me
problems. Does anybody knows how to do this?

Thank you.
Ivan.