Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to find the only one record for duplicate address?
Message
From
09/12/1998 13:49:15
 
 
To
08/12/1998 12:44:39
Senna Dwipayana
Indo Rebel Apparel Cv
Bandung, Indonesia
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00165174
Message ID:
00165707
Views:
15
I give an example. The table Family has the following records:
RECNO     NAME               DATE OF BIRTH     ADDRESS
1         father_a           Oldest            a_city     <- Select
2         mother_a                             a_city
3         son_a                                a_city
4         daughter_b                           b_city
5         grandmother_b      Oldest            b_city     <- Select
6         mother_c           Oldest            c_city     <- Select
I need to send ONLY ONE letter to every family that the member is the oldest, and all members of a family have the same address. So RECNO 1, 5 & 6 are selected.

How to write the SQL command to select these records?

Thanks in advance.
KK
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform