title: Writing a complex trigger
body: <p>I am using SQL Server 2000. I am writing a trigger that is executed when a field Applicant.AppStatusRowID</p>
  
  <p>Table Applicant is linked to table Location, table Company &amp; table AppStatus.</p>
  
  <p>My issue is creating the joins in my query.</p>
  
  <p>When Applicant.AppStatusRowID is updated, I want to get the values from
  Applicant.AppStatusRowID, Applicant.FirstName, Applicant.Lastname, Location.LocNumber, Location.LocationName, Company.CompanyCode, AppStatus.DisplayText</p>
  
  <p>The joins would be :</p>
  
  <pre><code>Select * from Applicant A
  Inner Join AppStatus ast on ast.RowID = a.AppStatusRowID
  Inner Join Location l on l.RowID = a.LocationRowID
  Inner Join Company c on c.RowID = l.CompanyRowID
  </code></pre>
  
  <p>This is to be inserted into an Audit table (fields are ApplicantID, LastName, FirstName, Date, Time, Company, Location Number, Location Name, StatusDisposition, User)</p>
  
  <p>My issue is the query for the inner join...</p>