Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Finding ALL items not ANY
How do you find like all orders that included a hammer AND nails? This is assuming a table normalized like ORDITEMS in TESTDATA. That is one item per record. INLIST(orditems.item,"hammers","nails") works fine for an 'ANY' scenario but not an 'ALL'
I need a single SQL statement if possible that will allow for multiple selections from a listbox to be searched for in a normalized table in an ALL fashion. There may be more than 2 selections so I can't just use a subquery since that's limited to one level deep.
Do I use a self join? Add a column for each item and use GROUP BY ordernum HAVING something? I can do it with multiple SQL statements searching on one item at a time then joining the resultant cursor with the next one but if there's a way to do it in one I'd like it better. I'm building a string that is eventually macro expanded. Thanks!
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement