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 ??

aF. · Accepted Answer · 2012-01-31 15:08:33Z

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, 2012 at 15:08

aF.

67k45 gold badges141 silver badges201 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

naresh · Accepted Answer · 2012-01-31 15:09:28Z

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, 2012 at 15:09

naresh

2,11321 silver badges33 bronze badges

where condition for both the tables are different.. Than how to approach?