title: teradata remove periods from one table that are in another table
body: <p><a href="https://i.stack.imgur.com/HsGEe.png" rel="nofollow noreferrer">tables for the problem</a></p>
  
  <p>I am trying to remove any periods or part of periods for the same id from one table if the period, or part of the period, appears in another table in Teradata.</p>
  
  <p>In the image as a reference.
  I would like to remove any periods from the start table if they appear in the remove table to get the result table
  All the group A rows would be removed and the B rows would be kept with the second B row being split into two periods.
  Is this possible?</p>