I don't have a problem just for future reference.

I see alot about left joins and stuff, and I think it's used for what I'm about to explain.

Say I have something like this for games:

id - title - description - categoryid
1 - Game - Description - 1

And the category table is like this:
id - category
1 - Games


I could do a query like
select category from categories where id = 'categoryid'

or whatever, but, is there anyway i can do this in one query, so i can select all of the games stuff, and the actual category name