Subject Re: [firebird-support] LEFT JOIN much faster than JOIN
Author Josef KokeŇ°
On 2.8.2013 13:59, Alexis Diel wrote:
>
>
> but LEFT JOIN is diferente of JOIN...
> - LEFT JOIN brings all the data filtered from the FROM table, and
> - JOIN brings only the data that have the ON condition in the JOINED table.

Which should make JOIN faster than LEFT JOIN, if anything, because it
can (potentionally) filter out some records.

Josef