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

Home -> Community -> Usenet -> c.d.o.misc -> Oracle Intermedia question

Oracle Intermedia question

From: Koen Van Tolhuyzen <Koen.VanTolhuyzen_at_cronos.be>
Date: Thu, 25 Nov 1999 16:23:07 +0100
Message-ID: <81jjqc$9vl$1@news3.Belgium.EU.net> 





Hi,



is it possible to have Oracle looked at several tables(tblPrograms) based on
one tabel (tblItems)


Those tables are connected to each other by tblItems_Programs



Is it possible to have a search like :


select tblItems.ID, tblItems.Content, tblPrograms.Name from ....
where contains(tblItems.Content, searchstring) > 0 and
contains(tblPrograms.Name, searchstring) > 0




Thanks in advance.



Koen


Koen.VanTolhuyzen_at_cronos.be





Received on Thu Nov 25 1999 - 09:23:07 CST












Original text of this message













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