Versions Compared

Old Version 9

changes.mady.by.user Former user

Saved on

compared with

New Version Current

changes.mady.by.user Former user

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Panel
nameblue

Join

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

 

What does this section cover?

Child pages (Children Display)

Attributes

NameDescriptionValue
indexorderThe order number of the join.Any number
outertableA The outer table name.Any table name that exists in database
innertableA The 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

Expand
titleJoin
Code Block
themeEclipse
languagexml
titleJoin
...
 
<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>
 
...