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'
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'