Struct Query In context

From: Netscape Admin <phil_at_waex.com>
Date: Thu, 25 Mar 1999 09:59:36 +0100
Message-ID: <36F9FAF8.8EC5E655_at_waex.com>

Hello there ..

Does anyone have experience with doing structured queries within Context.

Context is instqlled and running fine text queries and indeed structured queries run well. However I wish to run a structured query ... that joins to another table .. other than that of the table that contains my text column.

For instance ..

Example Table Structres:

Table: MSG

NUM                Number (Primary Key)
MSG_YEAR    Number
MSG_NUM     Number

MSG_LANGUAGE VARCHAR2
COUNTRY_ID VARCHAR2 Table: MSG_TEXT

NUM                primary Key
MSG_YEAR    Number
MSG_NUM     Number

TEXT I would like to be able to issue a CONTAINS statement that joins MSG_TEXT to MSG but searches for messages only from a certain country !!

regards

pod Received on Thu Mar 25 1999 - 09:59:36 CET