that there is a comma after the first INNER JOIN. I have written many
queries with joins and have not used a comma after an inner join. that
is probably your issue.
SELECT name,
FROM table1 as ft_tbl,
table2 as ft_tbl2
INNER JOIN
freetextTABLE (table1,*,'widget',100) AS KEY_TBL ON ft_tbl.ID =
KEY_TBL.[KEY], -- <-- DELETE COMMA THAT IS
HERE!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
INNER JOIN
freetextTABLE (table2,*,'wifget',100) AS KEY_TBL2 ON ft_tbl2.ID =
KEY_TBL2.[KEY]
ORDER BY KEY_TBL.RANK, namet asc
Kevin
-----Original Message-----
From: admin [mailto:[EMAIL PROTECTED]
Sent: Sunday, February 15, 2004 7:07 PM
To: CF-Talk
Subject: Re: SQL Freetext
yep catalogs are created and I can do a freetext search on just one :-
SELECT rank,id,name,instructions
FROM recipes as ft_tbl
INNER JOIN
freetextTABLE (recipes,*,'#class#',100) AS KEY_TBL
ON ft_tbl.ID = KEY_TBL.[KEY]
ORDER BY KEY_TBL.RANK desc
and it works great but with the code I wrote for two I get the standard
syntax error
[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the
keyword 'INNER'.
----- Original Message -----
From: Taco Fleur
To: CF-Talk
Sent: Sunday, February 15, 2004 4:26 PM
Subject: RE: SQL Freetext
What's the error you are getting?
Did you actually create the full-text catalog on the columns?
Taco Fleur
Blog <http://www.tacofleur.com/index/blog/>
http://www.tacofleur.com/index/blog/
Methodology http://www.tacofleur.com/index/methodology/
Tell me and I will forget
Show me and I will remember
Teach me and I will learn
-----Original Message-----
From: admin [mailto:[EMAIL PROTECTED]
Sent: Monday, 16 February 2004 10:22 AM
To: CF-Talk
Subject: sot: SQL Freetext
Just wondering if any one has some examples of how I can do the
following.
I need to do a freetext search on two tables and return the selections
by
rank - this is what I came up with but of course gets a syntax error
(no sql
manual around today !) - any suggestions would be much appreciated.
SELECT name,
FROM table1 as ft_tbl,
table2 as ft_tbl2
INNER JOIN
freetextTABLE (table1,*,'widget',100) AS KEY_TBL ON ft_tbl.ID =
KEY_TBL.[KEY],
INNER JOIN
freetextTABLE (table2,*,'wifget',100) AS KEY_TBL2 ON ft_tbl2.ID =
KEY_TBL2.[KEY]
ORDER BY KEY_TBL.RANK, namet asc
Cheers
Richard
_____
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
