If none one icon

If None One

The If None One icon inverts the result from the underlying query tree. If the underlying tree produces a record, no record is produced from this icon. If the underlying tree does not produce a record, then a default null value record is generated and returned. This icon is most commonly used to aid in implementing an SQL (LEFT) EXCEPTION JOIN, though it is used for other cases as well.