Update Fields With Searched First Date Record Fields

Hello !
I'm trying to update one table field with another table searched first
date record.
getting some problem.
If anyone have experience similar thing or have any idea about it,
please guide.

Sample case is given below.

Thanks in adv.
T.S.Negi


--Sample case

DROP TABLE TEST1
DROP TABLE TEST2

CREATE TABLE TEST1
(
CUST_CD VARCHAR(10),
BOOKING_DATE DATETIME,
BOOKPHONE_NO VARCHAR(10)
)

CREATE TABLE TEST2
(
CUST_CD VARCHAR(10),
ENTRY_DATE DATETIME,
FIRSTPHONE_NO VARCHAR(10)
)

DELETE FROM TEST1
INSERT INTO TEST1 VALUES('C1',GETDATE()+5,'11111111')
INSERT INTO TEST1 VALUES('C1',GETDATE()+10,'22222222')
INSERT INTO TEST1 VALUES('C1',GETDATE()+15,'44444444')
INSERT INTO TEST1 VALUES('C1',GETDATE()+16,'33333333')

DELETE FROM TEST2
INSERT INTO TEST2 VALUES('C1',GETDATE(),'')
INSERT INTO TEST2 VALUES('C1',GETDATE()+2,'')
INSERT INTO TEST2 VALUES('C1',GETDATE()+11,'')
INSERT INTO TEST2 VALUES('C1',GETDATE()+12,'')

--SELECT * FROM TEST1
--SELECT * FROM TEST2


/*
Sample data
TEST1
CUST_CD BOOKING_DATE BOOKPHONE_NO
C12005-04-08 21:46:47.78011111111
C12005-04-13 21:46:47.78022222222
C12005-04-18 21:46:47.78044444444
C12005-04-19 21:46:47.78033333333

TEST2
CUST_CD ENTRY_DATE FIRSTPHONE_NO
C12005-04-03 21:46:47.800
C12005-04-05 21:46:47.800
C12005-04-14 21:46:47.800
C12005-04-15 21:46:47.800

DESIRED RESULT
CUST_CD ENTRY_DATE FIRSTPHONE_NO
C12005-04-03 21:46:47.80011111111
C12005-04-05 21:46:47.80011111111
C12005-04-14 21:46:47.80044444444
C12005-04-15 21:46:47.80044444444
*/