MySQL Insert values from multiple table in one table in one query?

Question

I am using MySQL database.

Supposedly I have 3 table.

Table A : column ida
Table B : column idb
Table C: column A,B

I want to write a single through which I can insert values from Table A and Table B to Table C ??

How are tables A and B related? – D'Arcy Rittich Jan 31 '12 at 14:56 — D'Arcy Rittich, Jan 31 '12 at 14:56
and how do they relate to table C – bowlerae Jan 31 '12 at 15:00 — bowlerae, Jan 31 '12 at 15:00

score 2 · Accepted Answer · answered Jan 31 '12 at 15:08

2

It should be something like this

insert into tablec
select a.ida, b.idb
from tablea a
inner join tableb b on -- relation between tablea and tableb

but you'll have to finish inserting the relation between tables.

answered Jan 31 '12 at 15:08

aF.

score 0 · Answer 2 · answered Jan 31 '12 at 15:09

0

INSERT INTO C SELECT id1, id2 FROM A, B WHERE ...

I'm assuming that C has only tow columns and they are of same datatype as that of id1 and id2 from tables A and B. I hope you get the idea.

answered Jan 31 '12 at 15:09

naresh

where condition for both the tables are different.. Than how to approach? – Dhruv Feb 01 '12 at 04:29

2 Answers2