Subject | Re: LEFT JOIN doesn't work with view? |
---|---|
Author | Terry |
Post date | 2004-02-27T21:32:12Z |
--- In firebird-support@yahoogroups.com, Raúl Alberto Valencia
Najarro <valenciaraul2004@y...> wrote:
is not necessary to put it in. The results are the same.
Thanks for the try though! :-)
-Terry
Najarro <valenciaraul2004@y...> wrote:
> * You should use LEFT OUTER JOIN (use the three words) to includeall
> the records of MINERS, including those that do not have aActually, when LEFT, RIGHT or FULL are used, OUTER is implied, so it
> correspondence with the records in the view.
is not necessary to put it in. The results are the same.
Thanks for the try though! :-)
-Terry