Subject Re: LEFT JOIN doesn't work with view?
Author Terry
--- In firebird-support@yahoogroups.com, Raúl Alberto Valencia
Najarro <valenciaraul2004@y...> wrote:

> * You should use LEFT OUTER JOIN (use the three words) to include
all
> the records of MINERS, including those that do not have a
> correspondence with the records in the view.

Actually, when LEFT, RIGHT or FULL are used, OUTER is implied, so it
is not necessary to put it in. The results are the same.

Thanks for the try though! :-)

-Terry