3 - Outer Join

<addJoin kind="Outer" table="contact"  relation="contact2web_user" view="web_user_contact_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

addJoin Examples

1 - Inner Join

2 - Outer Join

4 - Inner Join with Aliases

Next

4 - Inner Join with Aliases

3 - Outer Join