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 (datatemp.newRegistration) Is Not
Null));
update aircraft set Registration = coalesce(
(select newregistration from datatemp
where newModeS = ModeS and newregistration != '.NO-REG' and
newRegistration is not null
) , Registration)
where Registration = '.NO-REG';
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users