List:General Discussion« Previous MessageNext Message »
From:Steffan A. Cline Date:July 1 2006 8:35pm
Subject:Full Text Search across 2 tables.
View as plain text  
I have 2 tables which have full text index on each of their columns.

Table 1 - forums_topics     field - topic
Table 2 - forums_messages   field - message
 
Is it possible to search them both in one query and determine which table
the result is being returned from in the search results?


Thanks

Steffan

---------------------------------------------------------------
T E L  6 0 2 . 5 7 9 . 4 2 3 0 | F A X  6 0 2 . 9 7 1 . 1 6 9 4
Steffan A. Cline
Steffan@stripped                             Phoenix, Az
http://www.ExecuChoice.net                                  USA
AIM : SteffanC          ICQ : 57234309
                                  Lasso Partner Alliance Member
---------------------------------------------------------------



Thread
Full Text Search across 2 tables.Steffan A. Cline1 Jul
  • Re: Full Text Search across 2 tables.Martin Jespersen2 Jul