title: SQL conditional data display based on multiple tables and columns
body: <p>I am attempting to display several columns of <code>tableX</code> data when the value of a specific column matches that of the corresponding column in <code>tableY</code>. </p>
  
  <p>Imagine we have 2 tables: one named <code>person</code> containing a column named <code>membershipid</code> and the other named <code>tasks</code>containing a column named <code>memberid</code>. In this case, the condition for display a record would be the following: </p>
  
  <p><code>membershipid</code> on <code>person</code> = <code>memberid</code> on <code>tasks</code> </p>
  
  <p>Does this require the use of a JOIN clause or can I still use the WHERE keyword for this?</p>
  
  <p>Thanks for taking a look.</p>