Re: [sqlite] Update Statements using Sub query

thanks Simon -- View this message in context: http://sqlite.1065341.n5.nabble.com/Update-Statements-using-Sub-query-tp80175p80181.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Update Statements using Sub query

] Gesendet: Dienstag, 20. Jänner 2015 14:10 An: sqlite-users@sqlite.org Betreff: [sqlite] Update Statements using Sub query I was wondering if anyone could help I am trying to use Excel to create update statements based on certain criteria. For example...this works UPDATE CDR_Adjusted SET

Re: [sqlite] Update Statements using Sub query

On 20 January 2015 at 13:09, MikeSnow wrote: > I was wondering if anyone could help > I am trying to use Excel to create update statements based on certain > criteria. > For example...this works > UPDATE CDR_Adjusted SET "DateTime"=DATE||" "||TIME; > (This is

[sqlite] Update Statements using Sub query

I was wondering if anyone could help I am trying to use Excel to create update statements based on certain criteria. For example...this works UPDATE CDR_Adjusted SET "DateTime"=DATE||" "||TIME; (This is what I need, a simple Concat 2013-10-11 7:59 But when I try to do this UPDATE