From: | "Nico" <nicohmail-postgresql(at)yahoo(dot)com> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: SQL Query Related |
Date: | 2004-12-26 12:31:46 |
Message-ID: | cqmavg$8l9$1@news.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
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.
"Rakesh Shembekar" <srakesh_22(at)yahoo(dot)com> schreef in bericht news:20041226102551(dot)24147(dot)qmail(at)web14301(dot)mail(dot)yahoo(dot)com(dot)(dot)(dot)
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!
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Cramer | 2004-12-26 17:04:27 | Re: SQL Query Related |
Previous Message | Rakesh Shembekar | 2004-12-26 10:25:51 | SQL Query Related |