INSERT ... SELECT ... AND
Hellau
i try to do a subquery on INSERT ... SELECT
i need the id of two entrys from one table and want to insert them into a nother table. also i want to insert a value to the same table.
this syntax doesnt work...
INSERT INTO a (ID1, ID2, C)
SELECT lemma.id
FROM lemma
WHERE lemma.lemma="my"
AND
SELECT lemma.id
FROM lemma
WHERE lemma.lemma="question"
AND
VALUE (4);
how can i do this?
thx for help. hope it was clear... my english isn't too good....
griits
Subject
Written By
Posted
INSERT ... SELECT ... AND
June 23, 2005 04:45AM
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.