<div class="Section1"><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">Hi,</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-GB" style="font-size:
10.0pt;font-family:Arial">While using Ms SQL server I used to write update statements like this,</span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span lang="EN-GB" style="font-size:
10.0pt;font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-GB"
style="font-size:
10.0pt;font-family:Arial">UPDATE a SET a.col1 = b.col1</span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanlang="EN-GB" style="font-size:
10.0pt;font-family:Arial">FROM table1 a</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
lang="EN-GB"style="font-size:
10.0pt;font-family:Arial">INNER JOIN table1 b</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
lang="EN-GB"style="font-size:
10.0pt;font-family:Arial">ON a.col2 = b.col2</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
lang="EN-GB"style="font-size:
10.0pt;font-family:Arial">WHERE a.col3 = ‘something’</span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanlang="EN-GB" style="font-size:
10.0pt;font-family:Arial">AND b.col3 = ‘somethingelse’</span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanlang="EN-GB" style="font-size:
10.0pt;font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-GB"
style="font-size:
10.0pt;font-family:Arial">But I can’t seem to do this in postgres, it gives me an error saying ‘syntax error at or near
“.”’.How can I do something similar to this i.e. join on the same table?</span></font><p class="MsoNormal"><font
face="Arial"size="2"><span lang="EN-GB" style="font-size:
10.0pt;font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-GB"
style="font-size:
10.0pt;font-family:Arial">Thanks,</span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-GB"
style="font-size:
10.0pt;font-family:Arial">/P</span></font></div>