On Mon, Dec 12, 2011 at 9:33 AM, Nick Smallbone wrote:
> "Black, Michael (IS)"
> writes:
>
> > Why do you have a subselectwhat are you doing there that you can't
> > do in the "on" clause?
>
> In the "real" example I'm joining with a view:
>
"Black, Michael (IS)"
writes:
> Why do you have a subselectwhat are you doing there that you can't
> do in the "on" clause?
In the "real" example I'm joining with a view:
create view v as select * from b where ...
select * from a left natural join v where id = 1;
nformation Systems
From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on
behalf of Nick Smallbone [n...@8325.org]
Sent: Saturday, December 10, 2011 4:35 PM
To: sqlite-users@sqlite.org
Subject: EXT :Re: [sqlite] Poor performance with nested quer
3 matches
Mail list logo