Conditions

Owned by Former user (Deleted)
Last updated: Oct 10, 2016 by Former user (Deleted)
1 min read

SQL conditions or expressions are used in clauses to select subsets of data.

Attributes

NameDescriptionValue
outerfield

The field of the outer table which will be used to join it with the inner table.

An existing field name from inner table
innerfieldThe field of the inner table which will be used to join it with the outer table.An existing field name from outer table
conditionThe compare operator.
=, >, <, >=, <=, <>
andorDetermines if the condition will be an AND or an OR.AND, OR

Example

 Conditions
Conditions
<conditions>
	<conditionitem>
		<outerfield>PRODTYPEID</outerfield>
		<condition>=</condition>
		<innerfield>PRODTYPEID</innerfield>
		<andor>AND</andor>
	</conditionitem>
</conditions>