title: What is the difference between the IN operator and = operator in SQL?
body: <p>I am just learning SQL, and I'm wondering what the difference is between the following lines:</p>
  
  <p>WHERE s.parent IN (SELECT l.parent .....)</p>
  
  <p>versus</p>
  
  <p>WHERE s.parent = (SELECT l.parent .....)</p>