to ask a question on join using insert statement

Question

hello suppose my table name is xyz in which three columns are there and another table abc also consist of three column, having id column common n both of them.normally we have seen that joins are used using select statement but i dont wana select column using join. i wana insert column using joins.i want to make use of insert statement in join not select. plz anyone answer ma question.

Answer 1

0

I'm not 100% sure what you are trying to do, but I hope this helps.

INSERT INTO jki
    (id)
    SELECT abc.id
    FROM abc
    	INNER JOIN xyz
    		ON xyz.id = abc.id

It will insert into table jki any id values that are found in both abc and xyz.

Another method that might work better for you in some situations is to use WHERE EXISTS:

INSERT INTO jki
    (id)
    SELECT abc.id
    FROM abc
    WHERE EXISTS
    	(SELECT * FROM xyz WHERE xyz.id = abc.id)

answered Feb 03 '10 at 03:58 PM

Tom Staab
5.8k ● 5 ● 8 ● 10

(comments are locked)

to ask a question on join using insert statement

Follow this question

Related Questions