PDA

View Full Version : Selecting from 2 tables



mobilebadboy
10-02-2007, 04:40 AM
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
10-02-2007, 04:59 AM
its right, EXCEPT no quotes around the very last part.

mobilebadboy
10-02-2007, 05:07 AM
Doh. Thanks, Chris.