title: Best way to use trigger to prevent deletion of a row where condition in another table is met?
body: <p>I want to create a trigger to prevent the deletion of a row in table_1 if a condition in a table_2 row with the same table_1ID is met (table_2.status = 'ON').</p>
  
  <p>I am not worried about deleting more than one row at a time.</p>
  
  <p>What would be the best way to go about this?</p>
  
  <p>Thanks in advance.</p>