Suppose I have following two tables:
Employee(Name, description, departiemtID,...) --foreign key: departmentID
Department(departmentID, name, description, ...)
I want to full-text search on Employee.Name, Employee.description, department.Name, department.description.
What's the best solution for this case? Demo query please.