1 - Inner Join

<addJoin kind="Inner" table="web_user"  relation="web_user2contact" view="web_user_contact_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

addJoin Examples

2 - Outer Join

3 - Outer Join

4 - Inner Join with Aliases

Next

2 - Outer Join
1 - Inner Join