Re: How to create a complex insert query?
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 );
Subject
Written By
Posted
Re: How to create a complex insert query?
April 22, 2009 04:11AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.