On 11/18/08, Christophe Leske <[EMAIL PROTECTED]> wrote:
>
>
> > When you add multiple tables into the FROM clause, you make a single
> > conceptual table out of them by using the JOIN operator.
> >
> So
>
> (with c1,c2,c3 all being rtrees)
>
> select * from (select * from c1,c2,c3) where
> Perhaps something like this:
>
> select * from
> (select * from c1
> union all
> select * from c2
> union all
> select * from c3
> ...
> )
> where foo1 < 10;
>
Yes!
And to answer Mike´s email as well:
these table represent higher and detailled data for deeper research, so all of
> When you add multiple tables into the FROM clause, you make a single
> conceptual table out of them by using the JOIN operator.
So
(with c1,c2,c3 all being rtrees)
select * from (select * from c1,c2,c3) where bla>10
is *not the same as
select * from c1 where bla>10
union all
select * from
On 11/18/08, Christophe Leske <[EMAIL PROTECTED]> wrote:
> Hi,
>
> pardon me if this is a pretty easy SQL question, yet i am after a
> statement compound which applies just ONE where clause to a group of
> tables.
>
> Something like
>
> select * from c1,c2,c3where foo1<10
>
> with
Christophe Leske <[EMAIL PROTECTED]> writes:
>
> Hi,
>
> pardon me if this is a pretty easy SQL question, yet i am after a
> statement compound which applies just ONE where clause to a group of
> tables.
>
> Something like
>
> select * from c1,c2,c3where foo1<10
>
> with foo1 being
"Christophe Leske" <[EMAIL PROTECTED]>
wrote in message news:[EMAIL PROTECTED]
> pardon me if this is a pretty easy SQL question, yet i am after a
> statement compound which applies just ONE where clause to a group of
> tables.
>
> Something like
>
> select * from c1,c2,c3where foo1<10
Hi,
pardon me if this is a pretty easy SQL question, yet i am after a
statement compound which applies just ONE where clause to a group of
tables.
Something like
select * from c1,c2,c3where foo1<10
with foo1 being in all of the specified tables. So far, all i can see is
that I have
7 matches
Mail list logo
