title: How to find changes in tables where multiple attributes exist?
body: <p>I'm having a brain melt down trying to figure this out, it's probably quite simple.</p>
  
  <p>I am trying to compare attribute changes between two tables.</p>
  
  <p>One table is historical, and the other is present, they have identical columns.</p>
  
  <p>Table1 (ID, Access)
  Table2 (ID, Access)</p>
  
  <p>Each ID may have multiple entries, ie access attribute stacks.
  So in Table1 it may show:</p>
  
  <p>ID | Access<br>
  1234 | Admin<br>
  1234 | Core<br>
  1234 | External</p>
  
  <p>And in Table2  </p>
  
  <p>ID | Access</p>
  
  <p>1234 | Admin<br>
  1234 | General<br>
  1234 | External</p>
  
  <p>I would like to see if a user has had any change in roles in Table2, so if the user has a role that they previously did not have in Table1.
  It does not matter if they no longer have a role, just to check if they have a role that they did not have in Table1.</p>
  
  <p>It is picking my brain because of the fact a user can have more than one role.
  I have tried several different queries and join methods, where I can show that side by side they have different roles. My results tend to show:</p>
  
  <p>ID | Table1 Access | Table2 Access</p>
  
  <p>1234 | Admin | General</p>
  
  <p>1234 | General | External</p>
  
  <p>1234 | External | Admin</p>
  
  <p>Where they are not equal.</p>
  
  <p>If this doesn't make sense, please tell me how I can explain it better, I wasn't sure how to use the mark-up properly on here as it has changed a lot since I last came here.</p>