Versions Compared

Old Version 9

changes.mady.by.user Former user

Saved on

compared with

New Version 10

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)

...

NameDescriptionValue
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

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