Thanks for the help, Dennis. I created a bug with ticket number 1035
for anyone interested in following up on this.
Thanks!
Bob
-Original Message-
From: Dennis Cote [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 16, 2004 2:01 PM
To: [EMAIL PROTECTED]
Subject: Re: [sqlite] Union
Bob Dankert wrote:
> I am trying to union two queries with each query having a sub-select
> defining the table, but I consistenly get no results if I try to limit
> the sub-query. Here is my query, assuming the table a and table
> contain one column filled with integers.
>
> Select * from (select
Bob Dankert wrote:
> I am trying to union two queries with each query having a sub-select
> defining the table, but I consistenly get no results if I try to limit
> the sub-query. Here is my query, assuming the table a and table
> contain one column filled with integers.
>
> Select * from (select
I am trying to union two queries with each query having a sub-select
defining the table, but I consistenly get no results if I try to limit
the sub-query. Here is my query, assuming the table a and table contain
one column filled with integers.
Select * from (select * from a limit 3) as a; <--
4 matches
Mail list logo