Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-10-18 : 19:17:02
|
| Murphy writes "Hi, I'm working on an Access database with ASP interface. I have two main tables, called "Items" and "Keywords". These tables are linked by a table called "KeywordLink". How can I build an SQL statement that will allow me to do a boolean search for records in "Items" that have multiple keywords. For example, I want to find all items that all have the keywords 'apples AND oranges AND bananas'. Or, I might want to find items that have 'apples OR oranges'. If all the keywords were strung together in one field, this would be easy, but since the keywords each have their own record, I am confused about how to accomplish this. Thanks so much!" |
|
|
|
|
|
boolean searches