Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: sql syntax ... join

Re: sql syntax ... join

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Fri, 16 Jan 2004 17:16:45 +0100
Message-ID: <bu926t$e71$1@news1.tilbu1.nb.home.nl> 





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

> 

> 




What were the errors when you tried?


And check out varchar2...

-- 

Regards,
Frank van Bortel


Received on Fri Jan 16 2004 - 10:16:45 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US