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?

Answer rating: 100% (QA)

In terms of efficiency the second query would likely be more efficient than the first query Heres wh... View the full answer