Try to avoid the subquery as much as possible because it slows down the execution and if you are retrieving a large amount of data then I would affect on the quality of the product. An inner join is the best for practice.