I would like some help with this query.
I have 3 tables I would like to search.
1 is an assets table and the second is a keyword table and the other is a assets_keyword table.
asset table:
| id | some other tables |
Keyword table:
| id | NAME |
The keyword name is in multiple languages, that's why I use the extra tables to link it to the asset.
asset_keyword table:
| ass_id | keyw_id |
How can I search the the assets_keyword table for multiple keyword id's?
If I try :
SELECT ass_id FROM asset_keyword WHERE keyw_id='115'
I only search for 1 keyword
If I try it with IN it works like OR, what I need is all the id's that have keyw_id 115 AND 117 AND 154.
How can I get this?
Kind regards,
Gerry.
