Or in left outer join.

[Kovax12]

What is the result of adding an or into a left outer join?

For example:

Select
l.list_id,
l.request_id
From List l
left outer join Request r
on l.request_id = r.request_id or l.list_id = r.list_id

Thanks :)

[David Portas]

Rows are joined if either condition is True; not joined if both are
False/Unknown.

Whatever the JOIN... ON expression it always results in a single value in
three value logic: True, False or Unknown. This determines whether rows are
joined or not - the JOIN happens if the expression result is True.

--
David Portas
------------
Please reply only to the newsgroup
--