SQL Query Related

Dear Masters

I want to retrieve data from table as following how can I build a query?
I will extact PRODUCT_ID from table say T_DAILY_SALE_DETAIL which is having column as
PRODUCT_ID which is char type.
Using this PRODUCT_ID I will extract another 2 product number which I am storing in table
say T_PRODUCT_MST having column names PRODUCT_TYPE and PRODUCT_SUB_TYPE both pf char datatype
Using PRODUCT_TYPE and PRODUCT_SUB_TYPE got from this query I want to retrive names of
of product from T_GOODS_KIND table.
How I can proceed?
Please help me out...

Raj

---

Do you Yahoo!?
The all-new My Yahoo! � Get yours free!