title: Cannot use text, ntext, or image columns in the 'inserted' and 'deleted' tables
body: <p>I got an error "Cannot use text, ntext, or image columns in the 'inserted' and 'deleted' tables", since there are ntext fields in original table, I had attached a trigger to.</p>
  
  <p>Here is a solution: <a href="http://lazycodeprogrammer.blogspot.com/2009/08/how-to-use-inserteddeleted-with.html" rel="noreferrer">http://lazycodeprogrammer.blogspot.com/2009/08/how-to-use-inserteddeleted-with.html</a></p>
  
  <p>But original (non modified) query is complex enough. What should I write instead of SELECT * FROM INSERTED, using JOIN operator, as it's recommended?</p>