MySQL Forums
Forum List  »  Newbie

INSERT ... SELECT ... AND
Posted by: Christos Bräunle
Date: June 23, 2005 04:45AM

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

Options: ReplyQuote


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.