> On Aug 21, 2015, at 12:10 AM, [email protected] [firebird-support] > <[email protected]> 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, Ann
