Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Patrick Danso
  Where is Patrick Danso?
 Accra
 Ghana
 Patrick Danso
 To: Anil Sharma
  Where is Anil Sharma?
 ludhiana
 India
 Anil Sharma
 Tags
Subject: RE: Selection Record per Member
Thread ID: 345570 Message ID: 345579 # Views: 41 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Thursday, May 24, 2012 4:23:12 PM         
   


> > Hi,
> >
> > I have a table with records of member’s payments. So this table have all payments of all members. I want to select ONLY one record per member from this table. How can i do this?
> > Thank you
>
> you can use select distinct fieldname .....
> better if you post with data.
>
>
>
> Anil
>
>
> Accounting Software
>
> Web Development
>
> Accounting, Inventory, Hotel Management, Restaurant Kot Billing, MLM, Excise Accounting and much much more!.
> My Blog

Payments table;
MemberID date Name
0001 01/01/12 Hook
0052 01/01/12 James
0003 13/02/12 Fred
0001 23/02/12 Hook
0011 25/02/12 Pat
0052 13/03/12 Peter

I want my result as below
Result table;
MemberID date Name
0001 01/01/12 Hook
0052 01/01/12 James
0003 13/02/12 Fred
0011 25/02/12 Pat


thanks

ENTIRE THREAD

Selection Record per Member Posted by Patrick Danso @ 5/24/2012 2:17:33 PM
RE: Selection Record per Member Posted by Cetin Basoz @ 5/24/2012 2:47:07 PM
RE: Selection Record per Member Posted by Anil Sharma @ 5/24/2012 2:58:11 PM
RE: Selection Record per Member Posted by Patrick Danso @ 5/24/2012 4:23:12 PM
RE: Selection Record per Member Posted by Tamar Granor @ 5/24/2012 10:18:10 PM
RE: Selection Record per Member Posted by Patrick Danso @ 5/25/2012 1:22:39 PM
RE: Selection Record per Member Posted by Anders Altberg @ 5/26/2012 2:45:14 PM