6 tables...different amounts of columns...nito one table

[sgtpepper]

I have 6 tables. I want to take the data from all 6 tables and insert it into one master table. The problem is...these tables do not have the same amount of columns.

How can I include all columns & data into the master table?

[LordShryku]

This may help http://www.phpbuilder.com/board/showthread.php?s=&threadid=10254230

[sgtpepper]

hmm...I am not sure if this is the same thing I need.

For example....

my table 1 has

field1,field2,field3,field4,field5

table2 has
field1,field2,field3

How can I merge these tables into one table...

[LordShryku]

ok, so lets say your master table has field1,field2,field3,field4,field5

childTable1 has
field1,field2,field3

As I understand, you want to take the data from childTable1 and insert it into master. If this is right, then you use

INSERT INTO master (field1, field2, field3) SELECT * FROM childTable1