Selecting from 2 tables

[mobilebadboy]

This is new territory for me, i've typically been a single table person.

I have 2 tables:

product_entertainment
- CategoryNumber
- ProductNumber
- Rank

image_entertainment
- several columns
- ProductNumber
- More columns

I want to select a specific CategoryNumber from product_entertainment and retrieve all of the information from image_entertainment where the ProductNumber matches the ProductNumber in product_entertainment.

If that makes sense.

I'm sure I'm way off, but this is what I tried to come up with (I hate learning new stuff sometimes).

select image_entertainment.*, product_entertainment.* 
from image_entertainment, product_entertainment 
where product_entertainment.CategoryNumber = '12911' 
and image_entertainment.ProductNumber 
= 'product_entertainment.ProductNumber' 

[Chris]

its right, EXCEPT no quotes around the very last part.

[mobilebadboy]

Doh. Thanks, Chris.