LEFT

Keyword LEFT

LEFT can be used as a string function or in a join clause.

String Function

Returns the left part of a character string with the specified number of characters.

Syntax:

    LEFT(character_expression, integer_expression)

Example:

    SELECT LEFT('abcdefg', 2); -- Returns 'ab'

LEFT JOIN

This keyword usually used in combination for join: [LEFT JOIN](Left Join).

Syntax:

    SELECT ... FROM table1 LEFT [OUTER] JOIN table2

See also: JOIN,RIGHT