Consider the following queries:

$1.$ SELECT $*$ FROM invoice

WHERE customer$\_$id IN

$($SELECT customer$\_$id FROM customer

WHERE first$\_$name like $\text{'}$J$\%\text{'})$;

$2.$ SELECT invoice.$*$ FROM invoice

INNER JOIN customer

ON customer.customer$\_$id $=$ invoice.customer$\_$id

WHERE first$\_$name like $\text{'}$J$\%\text{'}$;

Which of these would be the most efficient?