[RBASE-L] - RE: SQL Question

[Bill Eyring]

Duey
 
You might consider restructuring your contact table so each contact is
unique while tracking each contactdate.
Table structure might be;
 
CntId INTEGER AUTONUM 

CustId Integer (New) or something similar

CntNme TEXT 10

CntDte DATE

 

So your data would look something like this;

 

1,101,Dave,01/25/2008

2,102,Jack,05/09/1981

3,102,Jack,10/09/1985

4,101,Dave,01/01/1980

5,103,Sam,06/17/2004

 

This would create the 1 to 1 relationship Bill suggested making it easier to
do data retrieval and queries.

 

My .02.

 

Bill Eyring


  _____  

From: rbase-l@rbase.com [mailto:[EMAIL PROTECTED] On Behalf Of
Heffelfinger, Duane
Sent: Wednesday, October 08, 2008 10:01 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - SQL Question



I suspect this is a very easy SQL statement that I just can't think of
today.  I have a contact table with the following columns.

  CntId INTEGER AUTONUM

  CntNme TEXT 10

 CntDte DATE

 

And the following rows:

  1,Dave,01/25/2008

  2,Jack,05/09/1981

  3,Jack,10/09/1985

  4,Dave,01/01/1980

  5,Sam,06/17/2004

 

I want an sql statement that produces the contact id for the most current
contact of each individual.  The result should be:   

CntId

+++++

1

3

5

 

Thanks for any ideas.

 

Duey

 

P.S.  Hope we're playing golf after the conference on Monday?