Re: sequencing two tables

Stephan Szabo wrote:

>We don't support join conditions like the above at this point.  The
>message isn't terribly helpful though.
>
>
Purely out of interest, what does that message mean? Why aren't they
supported?

>Fortunately, I think some variant like
> select table1.field from table1
>  union all
> select table2.field from table2;
>will give you the output you're looking for.
>
>
It's exactly what I'm looking for. Thank you and Tom.

       Shachar

--
Shachar Shemesh
Lingnu Open Source Consulting ltd.
http://www.lingnu.com/