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

Absolutely. I'm sort of surprised you evern asked rather than just trying it.

Same goes for many functions such as UPPER, LOWER, DECODE, etc. Use every tool you can ... and in the context of a SELECT statement ... don't be afraid to just try it out ... on a small table of course.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)