On Thursday 07 July 2005 04:13 pm, Marvin Bellamy wrote:
> Thanks for the join tip. This must be a 3.2.1-specific bug, because
> that last example doesn't work for me. Looks like its been reported
> already.
Oops.. guess I missed that.
this works great:
sqlite> create view v2 as select a.id as
Thanks for the join tip. This must be a 3.2.1-specific bug, because
that last example doesn't work for me. Looks like its been reported
already.
--
Marvin Keith Bellamy
Software Engineer
Innovision Corporation
913.438.3200
Stephen Leaf wrote:
On Thursday 07 July 2005 02:19 pm, Marvin
On Thursday 07 July 2005 02:19 pm, Marvin Bellamy wrote:
> Can anyone explain why these queries don't work? And, is there a
> workaround?
>
> create table t1 (id int);
> create table t2 (id int, name varchar(32));
> create view v1 as select a.id, b.name from t1 a, t2 b where a.id=b.id;
ugly way
Can anyone explain why these queries don't work? And, is there a
workaround?
create table t1 (id int);
create table t2 (id int, name varchar(32));
create view v1 as select a.id, b.name from t1 a, t2 b where a.id=b.id;
select * from v1 where a.id=1;
select * from v1 where t1.id=1;
select *
4 matches
Mail list logo