views:

9

answers:

0

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.