[sqlite] Update Statements using Sub query

[MikeSnow]

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 CDR_Adjusted SET         "DateTime" =( 
           SELECT [Column Name]
             FROM Providers_Import
            WHERE Provider = 'abc' 
                  AND
                  Version = '2013-2014' 
                  AND
                  [Column Name] = 'Date' 
       ) || Time ;"

I get this....
Date || Time

Not the update, I would expect above
(In the table Providers_Input, the value in the [Column Name] is 'Date')

Thanks is advance




--
View this message in context: 
http://sqlite.1065341.n5.nabble.com/Update-Statements-using-Sub-query-tp80175.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users