Select Code to Download

id   action
---------------
...
 2     cd
 3     file
 4     zonk

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

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

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

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