FreeText with innerjoins ?

Question

1.00/5 (2 votes)

See more:

HI,
Can any one solve this freetex error while using with innerjoins

C++

select count(candid) from HR_Candidate where freetext(Category,a.Category) and somecondition

here 'a' is another table object, and category belongs that table

Posted 25-Jul-11 18:52pm

Comments

[no name] 26-Jul-11 4:31am

What is the error?

Tajuddin_HYD 26-Jul-11 5:52am

HI shameel
Msg 102, Level 15, State 1, Line 12
Incorrect syntax near 'a'.
this is the error which am getting

[no name] 26-Jul-11 15:15pm

Post your original script here.

1 solution

Add a Solution

Treat my content as plain text, not as HTML

…

Sign in to your account

Download, Vote, Comment, Publish.

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

S Douglas · Answer 1 · 2011-08-12T11:59:00

Just going on the query you posted here. You use the table alias 'a' in the freetext predicate but do not define that alias in the from clause.

SQL

select
    count(candid)
    from
        HR_Candidate a
where
    freetext(Category,a.Category)
    and
    somecondition

Posted 12-Aug-11 11:59am