Skip to end of banner
Go to start of banner

Join

Skip to end of metadata
  • Created by Former user, last modified by Former user on Oct 10, 2016
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 12 Current »

A SQL join clause combines records from two or more tables in a database.

 

What does this section cover?

Attributes

NameDescriptionValue
indexorderThe order number of the join.Any number
outertableThe outer table name.Any table name that exists in database
innertableThe inner table name.Any table name that exists in database
jointypeThe type of join.INNER, LEFT, RIGHT
conditionsThe conditions that follow the join.Conditions

Example

 Join
Join
<join>
	<indexorder>3</indexorder>
	<outertable>PRODUCTS</outertable>
	<innertable>PRODUCTFAMILIES</innertable>
	<jointype>LEFT</jointype>
	<conditions>
		<conditionitem>
			<outerfield>PRODFAMILYID</outerfield>
			<condition>=</condition>
			<innerfield>PRODFAMILYID</innerfield>
			<andor>AND</andor>
		</conditionitem>
	</conditions>
</join>
  • No labels