Query multiple tables and echo the result

[eluser]gmask[/eluser]
The `entries` table has an entry with the following structure

Code:

id -> '1'
title -> 'My Title'
content -> 'My Content'
category -> '1'

The `categories` table has an entry with the following structure

Code:

id -> '1'
title -> 'General'

In case I wasn't too clear in the first post what I want is to be able to change the

Code:

$entry->category

call in my view.php to display the corresponding category title instead of its id (which is obviously stored in the entry table itself). I understand this requires two queries, but I'm not sure how to go about it.

Thanks!