title: Trying to find any rows in a table shared by two other keys (in same table)
body: <p>I'm looking for a little help with some SQLite. I'm trying to write a query in a simple a way as possible. That is, with SQL statements rather than retrieving a set of data, then another set and comparing them by iterating through both.</p>
  
  <p>Looking at the extract of a table below:  I know both parent IDs and I want to find all the children IDs they have in common.  So parent 291 &amp; 673 have 755 in common.  They could have one, or more, children in common.</p>
  
  <p>How can I write a select statement to find 755?</p>
  
  <p>Thanks in advance for any thoughts.
  David</p>
  
  <p><img src="https://i.stack.imgur.com/waWKO.png" alt="enter image description here"></p>