title: pymysql-Combining the results of two different queried into
body: <p>I have done something like this:</p>
  
  <pre><code>sql_query1=...
  sql_query2=...
  
  cur.execute(sql_query1,(actorId1,actorId2))
  results1=cur.fetchall()
  
  cur.execute(sql_query2,(actorId1,actorId2)) 
  results2=cur.fetchall()
  
  nested_tuple_list1=[]
  for result in results1:
      nested_tuple_list1.append(result) 
  
  return(nested_tuple_list1) 
  
  nested_tuple_list2=[]
  for result in results2:
      nested_tuple_list2.append(result) 
  
  return(nested_tuple_list2) 
  </code></pre>
  
  <p>and I want to get the common results of the two queries.Any idea on what could I do?</p>
  
  <p>An example of what I need:</p>
  
  <pre><code>jim | tim | a      jim | dan | b
  dan | mo  | b      dan | mo  | b
  jim | dan | c       
  </code></pre>
  
  <p>I want to get: </p>
  
  <pre><code>dan | mo | b
  </code></pre>