Can you do a match against values from another table
Posted by:
Al Messa
Date: June 27, 2007 12:17PM
I would like to find records whose column contains any of the words from a column in a seperate table.
I tried doing something like the following but it does not work:
SELECT t1.*, t2.column_name2 FROM t1, t2 WHERE MATCH(t1.column_name1) AGAINST(t2.column_name2 IN BOOLEAN);
Any ideas of what would work? Or is this not possible at all? I am new to fulltext searching so I am not 100% of it's capabilites.
Thanks in advance
Al
Edited 1 time(s). Last edit at 06/27/2007 12:47PM by Al Messa.
Subject
Views
Written By
Posted
Can you do a match against values from another table
4364
June 27, 2007 12:17PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.