Re: sql syntax ... join

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 Received on Fri Jan 16 2004 - 10:38:41 CST