2 - Outer Join

<addJoin kind="Outer" table="web_user" relation="web_user2contact"  view="web_user_contact_view"/>


This will return all of the web_user records, and the associated contact 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

null

null

null

9

tnorton

See Also

addJoin Examples

1 - Inner Join

3 - Outer Join

4 - Inner Join with Aliases

Next

3 - Outer Join

2 - Outer Join