On Fri, Mar 14, 2008 at 5:53 PM, Dennis Cote <[EMAIL PROTECTED]> wrote:
> > You are aliasing the wrong thing. Try this instead: > > select * from (select user.id as id from user ) where id=1 ; > > If you want the subselect result to have a name then you can do this: > > select * from > (select user.id as id from user ) as sub where sub.id=1; > > Thanks Dennis. You and Igor really know this package well. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
