i know this should be very simple, and I have gone to the MySql KB and I just for some reason can't wrap my head around this. I have two tables table 1, has many fields, table 2 has fewer fields. The two tables have fields that are the same, (name, type, etc..) There is on link between them. I want to take all the fields from the larger table and insert ALL the records into the table 2 in the same fields. Can someone show me the way??
Thanks!
Thanks!