> My stab at an SQL statement to pull this change off is as follows: > UPDATE > Events SET Return = date(d, n + ' days') WHERE pkIndex IN (SELECT > pkIndex, Nights AS n, Departure AS d FROM Events WHERE Return = '' AND Nights > != '')
Why do you think you need the sub-select? Assuming that they syntax for the date function is correct, why would the below not work? UPDATE Events SET Return = date(departure, nights + ' days') WHERE Return = '' AND Nights != '' _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
