> 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
>
>
> >
> > 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.

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.