|
|
|
<view ...>
<join kind="Outer" table="web_user" relation="web_user2contact"></join>
</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 |
Next |