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
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
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
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
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
5 matches
Mail list logo