Get all Users from first table that have any word matching in another table;
I have Users table that contain, among others, column with FullName, that column is Full Text Search Indexed. Sometimes first "word" is name, sometimes first "word" is surname from the FullName column;
Like John Smith or Smith John.
And another table that have just local firstname.
I want to get all Users that have matching local name.
Users Table:
John Smith
Rebecca Mark
Maria Anna
Lance Maria
Emilia Clark
Snow John
Natalie Butler
Name Table:
Maria
Smith
Result of Query:
John Smith
Maria Anna
Lance Maria
Snow John
I can do only single Name with Contains function.
SELECT * FROM Users WHERE CONTAINS(FullName, 'John');
But I need it for each row in Name Table.
Every row from FullName contains any of Name Table... But in SQL Query.
JavaScript questions and answers, JavaScript questions pdf, JavaScript question bank, JavaScript questions and answers pdf, mcq on JavaScript pdf, JavaScript questions and solutions, JavaScript mcq Test , Interview JavaScript questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)