Mysql Query for inserting data from multiple tables

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Kanasz Robert · Answer 1 · 2012-02-03T05:29:00

Solution 1

Hi,

try this one:

insert into MyTable3(Field1, Field2) (select a.Field1, b.Field from MyTable2 as a, MyTable3 b where [EXPRESSION])

http://dev.mysql.com/doc/refman/5.0/en/insert-select.html[^]

Regards
Robert

Posted 3-Feb-12 5:29am

Kanasz Robert

Comments

Sridhar Patnayak 3-Feb-12 11:32am

Good answer and link 5+

Kanasz Robert 3-Feb-12 12:42pm

Thank's for vote :)

swapnilKumbhar 3-Feb-12 11:55am

yes it is..nice simple query he shown.
thanks helping hands

Kanasz Robert 3-Feb-12 12:42pm

I hope that this post will help you to solve your problem. If you have any other questions, just write :)

swapnilKumbhar 4-Feb-12 7:55am

i need urgent help on crystal report :|see mu Ques below

swapnilKumbhar 3-Feb-12 13:31pm

yes it helps me a lot...thnk u so much Robert
my new ques is about crystal report
I want to show all pages in crystal report like we see in pdf files(on leftside).
and how to show th pages on scroll up-down.
thank you :]