title: join in update command in trigger
body: <p>I have 3 tables, tbl_image, tbl_vehicle_image and tbl_vehicle</p>
  
  <p>tbl_vehicle_image resolves a many-many relationship between tbl_image and tbl_vehicle</p>
  
  <p>tbl_vehicle has a last_modified_date</p>
  
  <p>How do I create a trigger that, when I change for example tbl_image.img_lnk, uses tbl_vehicle_image to find all records in tbl_vehicle that use that image, and set their last_modified_date to NOW()?</p>