> > Hai Borislav,
> >
> > Thanks for the reply.
> > No,I dont have any mapping table.
> > I have only one table with productcodes and needlecodes.
> > I have ran the query
> >
> > SELECT distinct productcode,needlecode FROM newneedlecodes ORDER BY productcode,needlecode
> >
> > which gives the distinct combination of productcode and needlecode.
> > I hope this gives all the respective needlecodes for a particular product sort by.
> > If you have any suggestions please let me know.
> >
> > Regards,
> > Chandra
> >
> >
>
> OK, give me some simple date from both tables and what you want as a result from that data.
> I can't believe you can have nuts and bolts in cake, but who knows :-)
>
> -----------------
> Borislav Borissov
>
> Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
> The only thing normal about database guys is their tables.

Hai,

I have only one table.It is not 2 tables.
I want the output that should have the product code with all respective needlecodes.

Regards,
Chandra.