471,092 Members | 1,539 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,092 software developers and data experts.

Or in left outer join.

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 :)
Jul 20 '05 #1
1 2004
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
--
Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Justin Hennessy | last post: by
3 posts views Thread by Ian Boyd | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.