title: How to query an a row on two different tables with different IDs but the row points to the same value
body: <p>We have a pageID for each page on one table.</p>
  
  <p>When creating a draft for the page (by making a small change to the published version, a draft is generated) the draft has a different pageID. </p>
  
  <p>How can I address both the published and edited pageIDs?</p>
  
  <p>For example let's say we want query for PublishedID = 111 and DraftedId=34</p>
  
  <p>Of course, the ID will be parameterized and used in node/express</p>
  
  <pre><code>Table 1
  
  | PublishedId | category |      
  |-----        |----------
  | 111         | 123      
  | 111         | 123      
  | 222         | 123      
  | 222         | 123    
  
  
  Table 2
  
  | DraftedId  |isActive |      
  |-----       |----------
  | 23         | 1     
  | 43         | 0      
  | 34         | 1     
  | 22         | 0    
  </code></pre>