Something like (completely untested)
INSERT INTO types (typeID, description, typeGroupID)
SELECT v.C1, v.C2, typeGroups.typeGroupID
FROM (VALUES (RANDOM_UUID(), 'Evaluate'), (RANDOM_UUID(), 'Templates')),
typeGroups
WHERE typeGroups.description = 'Stay on Track';
Where you can use VALUES like a table, see:
http://h2database.com/html/grammar.html#values_expression
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/groups/opt_out.
