Is it possible to search 2 similar tables using freetexttable on both?eg :SelectRANK,ft.TOPIC_ID,ft.T_SUBJECT,ft.T_STATUSFROM (freetexttable(FORUM_TOPICS,*,'Test Text') as t join FORUM_TOPICS as ft on t.[key] = ft.TOPIC_ID)order by RANK desc;
Id like to join another table ft.topic_id = fr.topic_id, but rank give an ambiguous column name.It seems you cant use fr.rank and ft.rank - only rank?Are there anyworkarounds or suggestions you can make so that 2 columns of each table can be searched? (Id prefer to have them ranked!)tia 
Joining tables whilst using freetexttable
Posted - 2002-02-04 : 21:00:49