Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. sponsors. rss.
 From: chandu sekhar
  Where is chandu sekhar?
 miami
 Florida - United States
 chandu sekhar
 Tags
Subject: foxpro query
Thread ID: 233064 Message ID: 233064 # Views: 36 # Ratings: 0
Version: Visual FoxPro 9 Category: ODBC, ADO and OLEDB
Date: Monday, June 29, 2009 6:45:59 PM         
   


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.



COMPLETE THREAD
foxpro query Posted by chandu sekhar @ 6/29/2009 6:45:59 PM
RE: foxpro query Posted by Borislav Borissov @ 6/29/2009 7:08:31 PM
RE: foxpro query Posted by chandu sekhar @ 6/29/2009 7:20:17 PM
RE: foxpro query Posted by Borislav Borissov @ 6/29/2009 7:25:19 PM
RE: foxpro query Posted by chandu sekhar @ 6/29/2009 7:55:11 PM
RE: foxpro query Posted by Anders Altberg @ 6/29/2009 8:48:51 PM
RE: foxpro query Posted by chandu sekhar @ 6/29/2009 8:07:04 PM
RE: foxpro query Posted by Cetin Basoz @ 6/29/2009 7:29:47 PM
RE: foxpro query Posted by chandu sekhar @ 6/29/2009 7:58:13 PM
RE: foxpro query Posted by Anders Altberg @ 6/29/2009 8:10:12 PM
RE: foxpro query Posted by chandu sekhar @ 6/29/2009 8:40:33 PM
RE: foxpro query Posted by Anders Altberg @ 6/29/2009 8:52:10 PM
RE: foxpro query Posted by chandu sekhar @ 6/29/2009 9:08:24 PM
RE: foxpro query Posted by Anders Altberg @ 6/29/2009 11:00:07 PM
RE: foxpro query Posted by chandu sekhar @ 6/30/2009 4:12:31 PM
RE: foxpro query Posted by Anders Altberg @ 6/30/2009 4:41:10 PM