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


> > Hello Friends,
> >
> > I have a table that as two fields "Productcode" & "Needlecode".
> > This has many to many relationship.
> > What I means is:
> >
> > A single productcode can have lot of needlecodes.
> > A single needlecode can have lot of productcodes.
> >
> > What I need to generate is a report that should have by productcode with all respective needlecodes.
> > I have been thinking to write a query regarding that.
> > But i am not getting perfect thinking.I am totally clueless.
> > Please help me.
> > I will be so thankful to you.
> >
> > Thanks & Regards,
> > Chandra0315.
>
> Did you have some mapping table?
> If not how do you know which needle belongs to which product?
>
>
> -----------------
> 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.