Update Table Where It Matches Criteria From Another Table

I am trying to clean up an old database someone developed. I took the data and grouped the information that matched
I then imported it into a trips table. The matching data is all in the where statement. It shrunk 16k records for just under 2k records. Now I am trying to right a query to relate the 2 tables and update the tripid# to the triplist of people who actually attended.


Declare @Trip varchar(500)

Declare @Destination Varchar(500)

Declare @LeaveDate varchar(500)

Declare @LeaveTime Varchar(500)

Declare @ReturnDate varchar(500)

Declare @ReturnTime varchar(500)

Declare @Comment varchar(500)

Declare @RescheduleDate Varchar(500)

Declare @Rec int


Select @Rec = Rec# From Trips

Select @Trip = Trip from [Trips] where Trips.rec# = @Rec

Select @Destination = Destination from [Trips] where Trips.rec# = @Rec

Select @LeaveDate = LeaveDate from [Trips] where Trips.rec# = @Rec

Select @LeaveTime = LeaveTime from [Trips] where Trips.rec# = @Rec

Select @ReturnDate = ReturnDate from [Trips] where Trips.rec# = @Rec

Select @ReturnTime = ReturnTime from [Trips] where Trips.rec# = @Rec

Select @Comment = Comment from [Trips] where Trips.rec# = @Rec

Select @RescheduleDate = RescheduleDate from [Trips] where Trips.rec# = @Rec


Update TripList

SET tripid# = @Rec

WHERE (Trip = @Trip) and (Destination = @Destination) and (LeaveDate = @LeaveDate) and (LeaveTime = @LeaveTime) and (ReturnDate = @ReturnDate) and (ReturnTime = @ReturnTime) and (Comment = @Comment) and (RescheduleDate = @RescheduleDate)