Prefer JOIN over inner query.