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 select' message.
Remove the "[values]" and the parentheses around the select. Regards, Clemens _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
