[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sqlite-users
Subject:    Re: [sqlite] conditional queries against views
From:       Stephen Leaf <smileaf () smileaf ! org>
Date:       2005-07-07 21:37:11
Message-ID: 200507071637.11859.smileaf () smileaf ! org
[Download RAW message or body]

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 "id", b.name as "name" from t1 a 
inner join t2 b on a.id=b.id;

simply give them an alias.

sqlite> select * from v2 where id=1;
id|name
1|foo

this is also using 3.2.1
[prev in list] [next in list] [prev in thread] [next in thread]