Re: SQL Query Related

[Dave Cramer <pg(at)fastcrypt(dot)com>]

This is not really related to jdbc, please post to general, or for a 
more immediate, and interactive experience try #postgresql on 
irc.freenode.net

Dave

Rakesh Shembekar wrote:

> 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! <http://my.yahoo.com> – Get yours free! 


--
Dave Cramer
http://www.postgresintl.com
519 939 0336
ICQ#14675561