AND Truth Table - Teradata VantageCloud Lake

Lake - Working with SQL

Deployment: VantageCloud
Edition: Lake
Product: Teradata VantageCloud Lake
Release Number
Published: February 2025
ft:locale: en-US
ft:lastEdition: 2025-11-21
dita:mapPath: jbe1714339405530.ditamap
dita:ditavalPath: pny1626732985837.ditaval
dita:id: jbe1714339405530

The following table shows the AND logic used in evaluating search conditions.

x	y	x AND y
FALSE	FALSE	FALSE
	UNKNOWN	UNKNOWN
	TRUE	FALSE
UNKNOWN	FALSE	UNKNOWN
	UNKNOWN	UNKNOWN
	TRUE	UNKNOWN
TRUE	FALSE	FALSE
	UNKNOWN	UNKNOWN
	TRUE	TRUE