made a bit of a mess with this this is what i came up with from your instruction:
SELECT leads.*, Products.*
FROM Products
INNER JOIN leads
ON Products.ForeignKeyToleads = Products.PrimaryKey
basically in leads there is an enquirytype, in products there is 2 columns prdoid and prdouctname.
i want it to show the product name instead of productid?
many thanks again