I have two Oracle tables
first:
firstid: name
01 A
02 B
03 C
04 D
05 E
second:
secondid firstid date
01 01 01/01/1999
02 01 02/30/1998
03 01 07/29/2002
04 02 10/11/2002
05 02 11/01/2001
06 03 08/07/2000
07 03 03/09/2001
I would like to get a selection like this
firstid name date
01 A (the only one,the earlest date in the second table)
02 B
03 C
04 D
Thanks so much for any help.
first:
firstid: name
01 A
02 B
03 C
04 D
05 E
second:
secondid firstid date
01 01 01/01/1999
02 01 02/30/1998
03 01 07/29/2002
04 02 10/11/2002
05 02 11/01/2001
06 03 08/07/2000
07 03 03/09/2001
I would like to get a selection like this
firstid name date
01 A (the only one,the earlest date in the second table)
02 B
03 C
04 D
Thanks so much for any help.