postgresql - Merge multiple tables with a common column name -

I am trying to merge several tables that have the same column name, for which all the tables have the same Do not assume. For pre,

  -tmp1- id 1 1 234 2 432 3 412 -TMP2- ID name 1 GM 2 Ryan 4 jack -TMP 3-ID pin 1 GIS 2x4d 3 IIT 42 8 Hiue 11  

If there are inputs above, then output should be,

  Nomination of ID PIN 1 234 Jim GPS 2 432 x4ed 3 412 Ryan Yit42 4 Jack 8 Hiu11  

Thanks in advance.

postgresql 8.2.15R to green (pass-through queries)

How does this work in different combinations (provided that the tab1.row3 condition is < Code> tab2.row1 , and completes Tab1.row3 tab2.row2 ):

  | Tab 1 | | Tab 2 | Join | LEFT JOIN | | | Join right now. | Join The Full | -------- -------- ------------------------- --------- ---------------- ------------------------- --------- ---------------- | Line 1 | Tab1.row1 | | Tab1.row1 | | Line 2 | Tab1.row2 | | Tab1.row2 | | Line 3 | Line 1 | Tab1.row3 | Tab2.row1 | | Tab1.row3 | Tab2.row1 | | Tab1.row3 | Tab2.row1 | | Tab1.row3 | Tab2.row1 | | Line 4 | Line 2 | Tab1.row4 | Tab2.row2 | | Tab1.row4 | Tab2.row2 | | Tab1.row4 | Tab2.row2 | | Tab1.row4 | Tab2.row2 | | Line 3 | Tab2.row3 | | Tab2.row3 | | Line 4 | Tab2.row4 | | Tab2.row4 |