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
