1 - Inner Join

<view ...>
   <join kind="Inner" table="web_user" relation="web_user2contact"></join>
</view>

This inner 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

See Also

join Examples

2 - Outer Join

3 - Outer Join

4 - Example of Inner Join with Aliases

Next

2 - Outer Join
1 - Inner Join