|Subject||Re: [firebird-support] Join to same table twice - or joins vs subqueries|
> On Aug 21, 2015, at 12:10 AM, dmiller@... [firebird-support] <email@example.com> wrote: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.
> 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.