I can make head nor tales from your message. Give the table structures(name table+names & type fields). Then tell what you want to extract from it. Then I can help you. Kind regards, Nico.
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...