consultancy chorley ASP.NET Server Side Scripting Wigan
Website Development Radcliffe

A Coder's Notes

Email :
bespoke invoice systems Standish Information Technology Advice Worsley
    development systems Ramsbottom
data manipulation Farnworth access databases Whitefield SQL connections Atherton
online accessible software Leyland software compatible Coppull

Get connected and Online Tottington
remote management Makerfield code and design Aspull

MS Access UPDATE From One Table to Another - 30/03/2011

This will only work with MS Access sql.  I'm sure there'll be something similar for other flavours of SQL

UPDATE table1, table2 SET table1.field1 = table2.field1, table1.field2 = table2.field2 WHERE
   table2.fieldx = ??

Simples really...only if someone explains it to you.  Took me ages to find this.

Post A Comment

Name Comment
programming services specialist
Valid XHTML 1.0 Transitional