At least one icon

At Least One

The At Least One icon ensures that at least one (NULL-value-filled) record is produced, even if the underlying query tree does not produce any records. It is commonly used to aid in implementating an SQL (LEFT) OUTER JOIN, though it is used for other cases as well.