Postgres Pro
Downloads
Home   >   mailing lists

Thread: SQL Query Related

SQL Query Related

From
Rakesh Shembekar
Date:

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!

Re: SQL Query Related

From
"Nico"
Date:
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.

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!

Re: SQL Query Related

From
Dave Cramer
Date:
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