Jet Interview Question

Write the SQL code for joining these two tables.