id   action
---------------
 1     ls
 2     cd
 3     file
 4     zonk

##</code><code>##

id   product
-----------------
 1     /usr/bin
 2     /home
 3     /usr/tmp

##</code><code>##

p_id   a_id
-------------
 2      3
 1      3
 2      4

##</code><code>##

SELECT actions.action, products.product
FROM   actions, products, product_actions
WHERE  actions.id = product_actions.a_id
AND    product.id = product_actions.p_id

##</code><code>##

file /home
file /usr/bin
zonk /home  #don't try this one at home kids!