1) I'm trying to create a full text search facility for a small windows application which is running against a SQL Compact Edition database.
can this be done ?how?
im having two tables
id1 (id1,id2 are common in both the tables)
I have to select the values from 2 tables where keyword=(i will enter abc ->abc may present in any of the fields in 2 Tables)
How to write write sqlCE query for this