Value not entering

i have this sql statement, the "Name" column data is not storing any value when the sql statement is executed
here is the sql statement
SELECT Vessel_ArrivalDecRecieve.VeselRegNo, Vessel_Voyage.Name FROM Vessel_ArrivalDecRecieve INNER JOIN Vessel_ETA ON Vessel_ArrivalDecRecieve.ETAId = Vessel_ETA.ETAId INNER JOIN Vessel_Voyage ON Vessel_ETA.VoyageNo = Vessel_Voyage.VoyageNo AND Vessel_ETA.VeselRegNo = Vessel_Voyage.VeselRegNo WHERE (Vessel_ArrivalDecRecieve.ArrivalId = @ArrivalId) AND (Vessel_ArrivalDecRecieve.ArrivalYear = @ArrivalYear) AND (Vessel_ArrivalDecRecieve.ArrivalCuo = @ArrivalCuo) INSERT INTO [dbo].[Vessel_Control] ([VeselRegNo],[ArrivalDate],[ArrivalPort],[VoyageNo],[Name]) VALUES (@VeselRegNo ,@ArrivalDate ,@ArrivalPort,@VoyageNo,@Name) i want Name field from Vessel voyage to be saved in Vessel_Control table &quo ...