title: Update/Set multiple column with set and select statement
body: <p>I have below trigger written which works perfectly fine for single column update (firstname), however we now need to update few extra columns (lastname, mobileNumber etc.)</p>
  
  <pre><code>CREATE TRIGGER apl.updateJaWithCandidateDataAfterInsert ON [APL].[tblJobApplications_v2]
  AFTER INSERT
  AS
  SET NOCOUNT ON
  
  UPDATE [APL].[tblJobApplications_v2]
  SET FirstName = (
          SELECT FirstName
          FROM [USR].[tblUserDetails]
          WHERE inserted.CandidateId = [USR].[tblUserDetails].CandidateId
          )
  FROM [APL].[tblJobApplications_v2]
  INNER JOIN Inserted ON [APL].[tblJobApplications_v2].CandidateId = Inserted.CandidateId
  GO
  </code></pre>
  
  <p>Tried few options but couldnt make those work.Can someone please point me in the right direction?</p>