Re: Need Urgent help on SQL query

Hi,

would be nice to hear more about relationships between

CDSET and CD-PRINT and MEDIA_SET and CD-LABSET

On Mon, 6 Apr 1998 14:44:27 -0500, "Sree" <v-sreev_at_microsoft.com> wrote:

>Hi All ,
>
>I have two tables I need to get a sql report from this tables the data in
>the tables loaded using sql*loader. I tried in different ways but I couldnt
>able to get it right,
>I thought somebody out there more smart than me. I would like to know
>something like this possible or any other ideas of doing like this.
>I really appreciate your immediate response.
>
>You can reply to v-sreev_at_microsoft.com or SVupalanch_at_aol.com
>
>
>
>(TABLE A) The columns are item, loc, startdate, qty.
>
>ITEM LOC STARTDATE QTY
>
>A01 Hunt 01-jan-98 2000(TOTAL)
>
>
>(TABLE B)
>
>In table B the Columns are Item#, comp_part#, class, subclass
>
>ITEM# COMP_PART# CLASS SUBCLASS
>
>A01 X03-22163 Media CD
>A01 X03-43636 Media CD
>A01 X03-58632 Media CD
>A01 X03-53687 Media Set CD
>A01 X03-58631 Media Set CD
>A01 X03-61023 Media Set CD
>A01 X03-22156 Media Set CD PR
>A01 X03-43617 Media Set CD PR
>A01 X03-58629 Media Set CD PR
>A01 X03-09183 Print Mat CD Lab
>A01 X03-22172 Print Mat CD Lab
>A01 X03-43640 Print Mat CD Lab
>
>output should be in the followning format
>
>ITEM DATE QTY CDSET CD-PRINT MEDIA_SET CD-LABSET
>
>A01 01-jan-98 X03-22163 X03-22156 X03-53687 X03-9183
>A01 01-JAN-98 X03-43636 X03-43617 X03-58631 X03-22172
>A01 01-JAN-98 X03-58632 X03-58629 X03-61023 X03-43640
>
>
>
>
>
>
>
>

--

Regards

Matthias Gresz    :-)

GreMa_at_T-online.de