Nested Select?

[Manat]

Hello all

Ok, I have a product ID number(SKU), and I want to get the ageID for that SKU, meaning what is the target age group for this product.

So how do I do this? the SKU is in one table and the Age Group is in another.

So I want to select table1.groupID from table1 where table1.SKU =$SKU

And nested in this statement somehow, select table2.ageID from table2 where table2.AgeID = $groupID

I need to nest this in the same SQL statement, can anyone help me, please keep in mind these are two tables.

Thanks a bunch.

[YappyDog]

select SKU, AgeID
from table1, table2
where table1.SKU =$SKU
and table1.groupID = table2.AgeID