Hi!!! I was wondering how CONTAINS work in a dynamic sql statement where i have more than one table to join as below. FULL TEXT IS ENABLED ON TABLE emp This works. CODE select s.id from emp s WHERE CONTAINS(*, '"test"') This does not work CODE select s.id from emp s,emp1 s1 WHERE CONTAINS(*, '"test"') and s.id=s1.id I know the problem is * . But not sure how to use this just for emp table and not emp1 table Thanks!!