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_at_news3.Belgium.EU.net>



Hi,

[Quoted] 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 :
[Quoted] 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 - 16:23:07 CET

Original text of this message