AMLISTING"
>VALUES (1, 'one'), (2, 'two'), (3, 'three');</PRE
><P>

   This will return a table of two columns and three rows.  It's effectively
   equivalent to:

</P><PRE
CLASS="PROGRAMLISTING"
>SELECT 1 AS column1, 'one' AS column2
UNION ALL
SELECT 2, 'two'
UNION ALL
SELECT 3, 'three';</PRE
><P>

  </P
><P
>   More usually, <TT
CLASS="COMMAND"
>VALUES</TT
> is used within a larger SQL command.
   The most common use is in <TT
CLASS="COMMAND"
>INSERT</TT
>:

</P><PRE
CLASS="PROGRAMLISTING"
>INSERT INTO fi