 106, DEFAULT, 'Drama', DEFAULT);</PRE
><P>
  </P
><P
>   <TT
CLASS="COMMAND"
>VALUES</TT
> can also be used where a sub-<TT
CLASS="COMMAND"
>SELECT</TT
> might
   be written, for example in a <TT
CLASS="LITERAL"
>FROM</TT
> clause:

</P><PRE
CLASS="PROGRAMLISTING"
>SELECT f.*
  FROM films f, (VALUES('MGM', 'Horror'), ('UA', 'Sci-Fi')) AS t (studio, kind)
  WHERE f.studio = t.studio AND f.kind = t.kind;

UPDATE employees SET salary = salary * v.increase
  FROM (VALUES(1, 200000, 1.2), (2, 400000, 1.4)) AS v