4 - Example of Inner Join with Aliases

<view id="4352" name="fc_wipelm_case" groupName="Support">
   <viewColumn name="priority" tableName="gbst_elm" columnName="title" alias="gse_priority"></viewColumn>
   <viewColumn name="severity" tableName="gbst_elm" columnName="title" alias="gse_severity"></viewColumn>
   other view columns here...


   <join kind="Inner" table="gbst_elm" alias="gse_priority" relation="resp_priority2case" toAlias="" ></join>


   <join kind="Inner" table="gbst_elm" alias="gse_severity" relation="resp_severity2case" toAlias="" ></join>


   other joins here...


</view>











See Also
join Examples
1 - Inner Join
2 - Outer Join
3 - Outer Join



Next
exclusiveRelationSet











 4 - Example of Inner Join with Aliases