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/