I have multiple datatables containing multiple columns. I need to combine all of them to a single table. Here is an example:
TABLE1
==================================================
-ID---NAME---AGE---ACOLUMN3---ACOLUMN4---ACOLUMN5-
-----------------------------------------------
-1---JON----23------TRUE------FALSE-------TRUE
-2---JANE----29------TRUE-----FALSE-------FALSE-
-3---JOE----32------TRUE------TRUE--------TRUE
==================================================
TABLE2
==================================================
-ID---NAME---AGE---BCOLUMN3---BCOLUMN4---BCOLUMN5-
-----------------------------------------------
-1---JON----23-------TRUE------FALSE------TRUE
-4---JOEY----34------FALSE-----TRUE-------TRUE
-3---JOE----32-------TRUE------TRUE-------FALSE
==================================================
COMBINED TABLE
=================================================================================
-ID---NAME---AGE---ACOLUMN3---ACOLUMN4---ACOLUMN5---BCOLUMN3---BCOLUMN4---BCOLUMN5
---------------------------------------------------------------------------------
-1---JON-----23------TRUE------FALSE------TRUE-------TRUE------FALSE-------TRUE
-2---JANE----29------TRUE------FALSE------FALSE------FALSE-----FALSE-------FALSE
-4---JOEY----34------FALSE-----FALSE------FALSE------FALSE-----TRUE--------TRUE
-3---JOE-----32------TRUE------TRUE-------TRUE-------TRUE------TRUE-------FALSE
================================================================================
Can someone help me find the most efficient way to combine them. Thanks