[pysqlite] Error when using table alias

--===============0060008361==
Content-Type: multipart/alternative; boundary=0016364ec82c6242c004655c96ff

--0016364ec82c6242c004655c96ff
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

I am trying to run the following query using pysqlite:

select b.bookmark_id, b.title, b.url, b.created_date
from bookmark b
inner join (
    select btl.bookmark_id
    from bookmark_tag_lookup btl
    inner join tag t
        on btl.tag_id = t.tag_id
    where t.tag_name like '%c%'
) as agg0
    on b.bookmark_id = agg0.bookmark_id
inner join (
    select btl.bookmark_id
    from bookmark_tag_lookup btl
    inner join tag t
        on btl.tag_id = t.tag_id
    where t.tag_name like '%f%'
) as agg1
    on b.bookmark_id = agg1.bookmark_id

I'm receiving the following error: "pysqlite2.dbapi2.OperationalError: no
such column: agg1.bookmark_id".  Is this a bug?  I can run this query in an
SQLite editor and it runs without any problem.

I am using pysqlite 2.4.1 on Ubuntu Intrepid 8.10.

Thanks in advance.

--0016364ec82c6242c004655c96ff
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

I am trying to run the following query using pysqlite:<br><br>select b.book=
mark_id, b.title, b.url, b.created_date<br>from bookmark b <br>inner join (=
<br>=A0=A0=A0 select btl.bookmark_id<br>=A0=A0=A0 from bookmark_tag_lookup =
btl=A0=A0=A0 <br>
=A0=A0=A0 inner join tag t<br>=A0=A0=A0=A0=A0=A0=A0 on btl.tag_id =3D t.tag=
_id<br>=A0=A0=A0 where t.tag_name like &#39;%c%&#39;<br>) as agg0<br>=A0=A0=
=A0 on b.bookmark_id =3D agg0.bookmark_id<br>inner join (<br>
=A0=A0=A0 select btl.bookmark_id<br>
=A0=A0=A0 from bookmark_tag_lookup btl=A0=A0=A0 <br>
=A0=A0=A0 inner join tag t<br>
=A0=A0=A0=A0=A0=A0=A0 on btl.tag_id =3D t.tag_id<br>
=A0=A0=A0 where t.tag_name like &#39;%f%&#39;<br>
) as agg1<br>
=A0=A0=A0 on b.bookmark_id =3D agg1.bookmark_id<br><br>I&#39;m receiving th=
e following error: &quot;pysqlite2.dbapi2.OperationalError: no such column:=
 agg1.bookmark_id&quot;.=A0 Is this a bug?=A0 I can run this query in an SQ=
Lite editor and it runs without any problem.<br>
<br>I am using pysqlite 2.4.1 on Ubuntu Intrepid 8.10.<br><br>Thanks in adv=
ance.<br>

--0016364ec82c6242c004655c96ff--

--===============0060008361==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
list-pysqlite mailing list
list-pysqlite-FR6EJeJVuqdwc357pe9rcyQmJico6nz3epZhswDD4dQ@public.gmane.org
http://itsystementwicklung.de/cgi-bin/mailman/listinfo/list-pysqlite
--===============0060008361==--