> 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
Hello,
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 (
load_tsl.dict_load_type_id = bload.dict_load_type_id
