I have five tables with some same fields but with some different primary keys.
now i want to export data from all these tables to another table with some selected fields from each table.
table1 -f1 pk -f2 - f3 -f4
table2-- f1 pk -f2 -g1 -e
table3 -g pk -f1...
