Re: How to create a complex insert query?

[Linda van der Pal]

Just had some help from a friend who helped me figure it out. Just in case anybody else ever encounters the problem:

insert into gebruiker_has_rol (Gebruiker_ID, Vriend_ID, Rol_ID)
(SELECT GID.*, VID.*, RID.* FROM
(SELECT 2 FROM DUAL) AS GID,
(SELECT 4 FROM DUAL) AS VID,
(SELECT ID FROM rol WHERE Naam = 'OWNER') AS RID );