On 1/8/2015 6:12 PM, MikeSnow wrote:
"Error while executing query: no such column: t1.*B.Switch-Tower-Sector"
but, the column, t1.[*B.Switch-Tower-Sector], does exist. I get results
when I do
select[*B.Switch-Tower-Sector] from t1;
but an error when I do the UPDATE statement...
UPDATE t2
SET [*B.ANT_ORIENTATION] =
(SELECT t2.ANT_ORIENTATION
FROM t2
WHERE
t2.[*SSID-CELLID-SECTOR] = t1.[*B.Switch-Tower-Sector]);
Before you can use a table name elsewhere, you must introduce it in a
FROM clause (or INSERT INTO, UPDATE or DELETE clause).
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
