Re: sql syntax ... join

From: Turkbear <john.g_at_dot.spamfree.com>
Date: Fri, 16 Jan 2004 10:45:17 -0600
Message-ID: <s65g00p1664ud11ss7699ul5s90kqtb553@4ax.com>

Holger Baer <holger.baer_at_science-computing.de> wrote:

>Jon wrote:
>> Hi, I like to know if it is possible to make a simple join but based on an
>> expression like the following one
>>
>> select * from table1 a, table2 where a.trim(cod) = b.cod
>>
>> thanks
>>
>>
>
>It should work as long as you get the syntax right:
>
>select * from table1 a, table2 where trim(a.cod) = b.cod
>
>With your example, I get ora-00904 invalid column name.
>
>HTH
>
>Holger

And b.cod is from where?

Shouldn't it be:
select * from table1 a, table2 b where trim(a.cod) = b.cod; Received on Fri Jan 16 2004 - 10:45:17 CST