On 1/29/2015 12:36 PM, Sterpu Victor wrote:
>
> ON(null) never matched.
NULL is neither true nor false.
ON somefieldinthejoin IS NULL would be a valid syntax. except,
that's NOT a join condition, a join condition would be ON
left_table.something = right_table.something
> ON (1=1)
equivalent to ON TRUE
but that will cross join everything, so if the left table has N rows
and the right table has M rows, you'll end up with N*M rows in the
result. is that really what you want ??
--
john r pierce 37N 122W
somewhere on the middle of the left coast