Shachar Shemesh <[EMAIL PROTECTED]> writes:
> 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?
I'll take a swing at this.
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
sele
On Sun, 28 Nov 2004, Shachar Shemesh wrote:
> I need to create a list of all rows of the combination of two tables.
> For reasons I can't go into, I need this list to be in a single query,
> and not write a function to do it.
>
> I thought about doing something like this:
> select |COALESCE(table1
Shachar Shemesh <[EMAIL PROTECTED]> writes:
> I thought about doing something like this:
> select |COALESCE(table1.field, table2.field) as field from table1 full
> outer join table2 on false
Perhaps you are looking for UNION ALL? If not, I'm not sure what you
expect this query to mean.
Hi list,
I need to create a list of all rows of the combination of two tables.
For reasons I can't go into, I need this list to be in a single query,
and not write a function to do it.
I thought about doing something like this:
select |COALESCE(table1.field, table2.field) as field from table1 fu
