> Conditions in WHERE are conditions logically applied after the join, so
> the second query is join rows of booking_load with rows of
> dict_load_type_tsl that have the same dict_load_type_id and if no such
> rows in dict_load_type_tsl are found extend with NULLs then throw out any
> rows for whic
On Mon, Nov 14, 2005 at 14:45:22 +0100,
Michał Otroszczenko <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I wonder If I could move additional join condition from ON part of
> query to where part.
Yes, but the semantics are different for outer joins.
>
> For example instead of:
>
> SELECT * FROM
>
On Mon, 14 Nov 2005, [ISO-8859-2] Micha? Otroszczenko wrote:
> I wonder If I could move additional join condition from ON part of
> query to where part.
>
> For example instead of:
>
> SELECT * FROM
> booking_load AS bload
> LEFT OUTER JOIN dict_load_type_tsl AS load_tsl ON (
>
