hey all,

I have three related tables that need data manually edited, I'm using phpMyAdmin to export the tables in CVS excel format for field editing, is there a way to join those tables together for export? Right now they look like this in excel;

id table1 field1
01 xxxxxxxxxx
02 xxxxxxxxxx
03 xxxxxxxxxx

id table2 field1
01 xxxxxxxxxx
02 xxxxxxxxxx
03 xxxxxxxxxx

id table3 field1
01 xxxxxxxxxx
02 xxxxxxxxxx
03 xxxxxxxxxx

I'm having a hard time editing as the tables show up one after the other, I'd like to export them like this;

id table1 field1 table2 field1 table3 field1
01 xxxxxxxxxx xxxxxxxxxx xxxxxxxxxx
02 xxxxxxxxxx xxxxxxxxxx xxxxxxxxxx
03 xxxxxxxxxx xxxxxxxxxx xxxxxxxxxx

how can this be accomplished? and how would i later import the updated fields?

I'm new to SQL and phpMyAdmin I'd really appreciate your help