Hm, I even tried a join statement and that didn't work...
this is quite gruelling...
Code:
select users.referer, contact_id, sales_id, product_no,contact_id from sales, salesdetail
from users, sales, salesdetail join salesdetail on sales.sales_id = salesdetail.sales_id
and salesdetail.product_no = #pnumber#;