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:
> create view v as select * from b where ...
> sele
"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;
IIUC, when I execute th
Why do you have a subselectwhat are you doing there that you can't do in
the "on" clause?
Can you show your subselect? Your example isn't enough.
Michael D. Black
Senior Scientist
Advanced Analytics Directorate
Advanced GEOINT Solutions Operating Unit
Northrop Grumman Information
3 matches
Mail list logo