Re: [sqlite] insert / replace into joined tables.

2013-03-01 Thread chas cartmel
ie Rainford, UK == -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Igor Tandetnik Sent: 01 March 2013 14:14 To: sqlite-users@sqlite.org Subject: Re: [sqlite] insert / replace into joined tables. On 3/1/201

Re: [sqlite] insert / replace into joined tables.

2013-03-01 Thread Igor Tandetnik
On 3/1/2013 8:29 AM, chas cartmel wrote: The working MS Access SQL : UPDATE aircraft INNER JOIN datatemp ON aircraft.ModeS = datatemp.newModeS SET aircraft.Registration = [datatemp.newregistration] WHERE (((aircraft.Registration)=".NO-REG") AND ((datatemp.newRegistration)<>".NO-REG" And (datate

Re: [sqlite] insert / replace into joined tables.

2013-03-01 Thread Simon Davies
On 1 March 2013 13:29, chas cartmel wrote: > Hi guys/gals. > > First post to this group. > > I have a problem which can be solved in Access/ SQL Server but not seemingly > in SQLite. I am trying to update a value in a table from another identical > table where that value has been updated elsewhere

Re: [sqlite] insert / replace into joined tables.

2013-03-01 Thread Clemens Ladisch
chas cartmel wrote: > I have tried the "REPLACE INTO aircraft [values] (select combined > columns here ... from aircraft,datanew where ModeS = newModeS and > registration = ".NO-REG" and newregistration is not null); " as suggested > elsewhere on this forum. > > I keep getting an 'error near

[sqlite] insert / replace into joined tables.

2013-03-01 Thread chas cartmel
Hi guys/gals. First post to this group. I have a problem which can be solved in Access/ SQL Server but not seemingly in SQLite. I am trying to update a value in a table from another identical table where that value has been updated elsewhere. Do not want to delete insert and the original entry m