I got it...so happy,
thanks guys
--
View this message in context:
http://sqlite.1065341.n5.nabble.com/Error-while-executing-query-no-such-column-t1-B-Switch-Tower-Sector-tp79905p79930.html
Sent from the SQLite mailing list archive at Nabble.com.
___
s
executing query: no such column:
t1.*B.Switch-Tower-Sector
I was wondering if anyone could let me know where I am going wrong. I am
getting the error...
"Error while executing query: no such column: t1.*B.Switch-Tower-Sector"
but, the column, t1.[*B.Switch-Tower-Sector], does exi
On 2015/01/09 01:12, MikeSnow wrote:
I was wondering if anyone could let me know where I am going wrong. I am
getting the error...
"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[*
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
On 8 Jan 2015, at 11:12pm, MikeSnow wrote:
> UPDATE t2
> SET [*B.ANT_ORIENTATION] =
> (SELECT t2.ANT_ORIENTATION
> FROM t2
> WHERE
> t2.[*SSID-CELLID-SECTOR] = t1.[*B.Switch-Tower-Sector]);
You do not mention a specific row of t1, so it doesn't know what value you're
talking about.
Simon.
I was wondering if anyone could let me know where I am going wrong. I am
getting the error...
"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
6 matches
Mail list logo
