MERGE and WITH ?

Does MERGE work with "WITH" clause ???
like:

WITH
sub_sql
AS
(some_select)
MERGE INTO targettable
  USING sub_sql
........

thanks Received on Mon Oct 16 2006 - 12:37:14 CDT