title: Query using email address to get user ID as key to query a second table
body: <p>The User table has UserEmail and UserID</p>
  
  <p>The Purchases table uses UserID as the key.</p>
  
  <p>Currently I am manually doing a UserEmail search on the User table to find out User IDs then manually searching the Purchases table to export records. I would really love help with a query (which I'll use with Phpmyadmin) so I can do 1 query on the Purchases table using UserEmail to get results.</p>
  
  <p>I hope this makes sense and I thank you.</p>