<div>
Thanks Simon . But is this tested in MS Access &nbsp;? I am getting an error &nbsp; &quot;Syntax error &nbsp;Missing operator<br />
&nbsp;in query expression &nbsp;from tableA &nbsp;as &nbsp;A inner join tableB as B on A.Primkey=B.Primkey
</div>


Thanks Simon . But is this tested in MS Access  ? I am getting an error   "Syntax error  Missing operator
 in query expression  from tableA  as  A inner join tableB as B on A.Primkey=B.Primkey

<div>
Sorry, not tested on Access, and written with the wrong flavour of SQL in mind. Apologies
</div>


Sorry, not tested on Access, and written with the wrong flavour of SQL in mind. Apologies

<div>
<div class="content wysiwyg-content">
Hi ,<br />
<br />
&nbsp; &nbsp; &nbsp;I was looking for the query to update a few colums (col1,col2,col3) &nbsp;in TableA &nbsp; from an identical table TableB &nbsp;( where the condition TableA.PrimKey = TableB.PrimKey)<br />
<br />
&nbsp; &nbsp;Can you please help
</div>
</div>


Hi ,

     I was looking for the query to update a few colums (col1,col2,col3)  in TableA   from an identical table TableB  ( where the condition TableA.PrimKey = TableB.PrimKey)

   Can you please help

MS Access 2010 Query to update one table from another

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.