Amazon Interview Question

Write a SQL query to join two tables.