"Where contains" statement with subquery
<p>I have a problem with SQL statement like this</p>

<pre><code>SELECT e.id, e.name, d.name as department_id

FROM (FROM (SELECT id, name, department_id
            FROM employee
            WHERE address = 'Texas' ) e
     JOIN department d
     ON e.department_id = d.id )

WHERE CONTAINS( (e.name, d.name), 'user_input_for_search')
</code></pre>

<p>When execute the SQL, I got the error message:
"feature not supported: functions for full text search doesn't support columns from subquery"</p>

<p>Could someone teach me how to solve it?</p>

<p>Thanks</p>