title: How to join two dataframes with option as in Pandas
body: <p>My goal is to translate this below join into PySpark</p>
  
  <pre><code>merged_df = df1.merge(df2, 
                          left_on=['user','timestamp1'], 
                          right_on=['user','timestamp2'],
                         how='left')
  </code></pre>
  
  <p>I did this but it isn't the desirable result</p>
  
  <pre><code>merged_df = df1.join(df2, 
                       (df1.user==df2.user) &amp; (df1.timestamp1==df2.timestamp2), 
                       how='left')
  </code></pre>