On 9/7/06, Emi Lu <[EMAIL PROTECTED]> wrote:
I tried the example as the following:create table a(col1);create table b(col1, col2)select a.*from a inner join b using(col2)left join b.col2 as c on (c.col1 = a.col1)System notifies me that b is not a schema name.
So, I guess the approach that I tried t
On Thu, 7 Sep 2006, Emi Lu wrote:
> Hello,
>
> Is it possible to do something like:
>
> select ...
> from t1
> inner join t2 ...
> left join t2.colN
>
> When t1 inner join with t2 I got unique result for t2.colN( colN's value
> is table name).
>
> Can I continue to left join with the column "colN"
I tried the example as the following:
create table a(col1);
create table b(col1, col2)
select a.*
from a inner join b using(col2)
left join b.col2 as c on (c.col1 = a.col1)
System notifies me that b is not a schema name.
So, I guess the approach that I tried to do is not acceptable by Pgsql
g
Hello,
Is it possible to do something like:
select ...
from t1
inner join t2 ...
left join t2.colN
When t1 inner join with t2 I got unique result for t2.colN( colN's value
is table name).
Can I continue to left join with the column "colN" in table t2?
Thanks
---(
