In table_b, word_1 has the first word of the description field for each record in this table, word_2 has the second word of the description field for each record in this table, and so on: select a.*, b.* from table_a a, table_b b where a.descrip like b.word_1 and a.descrip like b.word_2 and a.descrip like b.word_3 and a.descrip like b.word_4 and a.descrip like b.word_5 and a.descrip like b.word_6
|Query criteria to get previous month's data not working||3||27|
|SQL Server 2008 R2 - Execution Plan||3||31|
|Cannot install / add SQL database when installing MyCalls software||22||48|
|SQL error: "expression of non-boolean type specified in a context where a condition is expected, near 'WHERE'"||6||36|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
11 Experts available now in Live!