Versions Compared

Old Version 10

changes.mady.by.user Former user

Saved on

compared with

New Version 11

changes.mady.by.user Former user

Saved on

Key

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

Join

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

Child pages (Children Display)

Attributes

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

...

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>
 
...