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-16 : 19:06:44
|
David writes "I have a many-to many relationship with three tables. An ITEMS table, a KEYWORDS table and an ITEM_KEYWORD table to join them.
I want to query this database to find items that have more than one keyword associated with it, but I want to be able to exclude records. In other words, I'm essentialy trying to run an AND condition on the same field in the KEYWORDS table. This, of course, can't be done!
How can I make this work!?!?" |
|
|
|
|
|
Searching by Keywords in SQL