Advantages of Joins
Advantages of Subqueries
Can Include Columns from Both Tables
More intuitive when using existing relationships
Can pass an aggregate value to the main query
More Intuitive when using an Ad hoc Relationship
Long complex queries can be easier to code
Either approach can be used, but depending on your situation one approach may be easier