So we have 2 tables
id | username | email 1 | testuser | firstname.lastname@example.org 2 | dirk | email@example.com
id | data | username 1 | somedata | dirk 3 | somemoredata | testuser
I want to select the username of the data table with the id 3 and then select his email. Which is the nicest way to do this with an inner join?