I'm try to write a t-sql query like this:
select * from table1 t1
where exists (select * from table2 where CONTAINS(Col1, t1.Col1))
But the error is:
Incorrect syntax near 't1'.
There is a FTI on table2 with Col1 included. It's working fine when I hardcode a value like this:
select * from table2 where CONTAINS(Col1, 'value here')
How do I make this work?