3 - Outer Join

<view ...>
   <join kind="Outer" table="contact" relation="contact2web_user"></join>
</view>

This will return all of the contact records, and the associated web_user records if they exist.
This outer join will result in the following data being returned:

Contact Objid

First Name

Last Name

Web User Objid

Login Name

1

Bill

Smith

7

bsmith

2

Mary

Jones

8

mjones

3

Fred

Miller

null

null

See Also

join Examples

1 - Inner Join

2 - Outer Join

4 - Example of Inner Join with Aliases

Next

4 - Example of Inner Join with Aliases

3 - Outer Join