Write a basic SQL query to retrieve data from two tables using an inner join and a filtering condition.