trigger - to capture data into history table

Do I need to join inserted table for the above code like below:

      Else 
Begin   
           SELECT  del.StudentID ,
                            del.AddressID ,
                            del.ApartmentNum ,
                            del.MoveEffectiveDt ,
                            COALESCE(del.ChangeDt, del.CreateDt, SYSDATETIME()) ,
                            COALESCE(del.ChangedBy, del.CreatedBy, SYSTEM_USER)
                    FROM    deleted del
                            INNER JOIN inserted ins ON del.studentID = ins.StudentID
End

---

SQLFriend