Combining tables in MySQL

[dc2_jspec]

Ok, this is what I am wanting to do. I need to "merge/combine" two tables in MySQL. I don't know if this is possible. I basically have two different tables with different fields in them. I want to create a totally seperate larger table with all the fields of table_one and all the fields of table_two along with the values of each table. is this possible to do, remember the fields are not called the same thing and do not contain the same sort of information? thanx in advance.

[weekender]

ok you need to make an outer join query (read mysql help), which will include all fields from table1 and all from table2 without needing a linking field. run this as a select query so you are sure it is returning the correct data, then change it to a make table query (if you need the table to be fixed).

adam