title: How to do outer join on two columns in Pig Latin
body: <p>I do outer joins on single columns in Pig like this</p>
  
  <pre><code>result = JOIN A by id LEFT OUTER, B by id;
  </code></pre>
  
  <p>How do I join on two columns, something like -</p>
  
  <pre><code>WHERE A.id=B.id AND A.name=B.name
  </code></pre>
  
  <p>What is the pig equivalent?  I couldn't find any example in the pig manuals...any help?</p>