Exporting/Importing certain fields with phpMyAdmin

[Delaran]

Hey all,

 

I've tried this a few different ways and maybe I need to do with with straight SQL.  I thought maybe someone here may know, so here goes:

 

I have two tables I need values from and I am trying to create a third composed of the fields from both that I need.  Let's say table 1 has id, name, description and table 2 has price, amount per case, quantity on hand, etc.

 

I tried using the operations panel but found no option to do just this.  I used the export function and got an SQL file saved to my desktop, but it attempts to create a table when I try to import it... is there a way to select certain fields from a table and copy them to another?

[PC Nerd]

um, I dont know about the different export options, but one says create, import ,insert etc... within the sql type.  this create the SQL to create tables, or simply insert data etc.  the other thing you could do is just delete the section that create the table or database.  that what i do when i simply need the inserts.

 

good luck