Subject Re: [firebird-support] Join to same table twice - or joins vs subqueries
Author Ann Harrison
> On Aug 21, 2015, at 12:10 AM, dmiller@... [firebird-support] <> wrote:
> If subselects don't offer a performance advantage, and since I find them
> far more confusing than join syntax - I guess I'll forget about them
> until I have a problem they're designed to solve.

Subselects are harder to optimize than joins. In a straightforward query like yours it doesn't make any difference, but in some cases a query with subqueries will be slower than one that uses inner joins.

Good luck,