I'm not sure how to do this so I don't know if I would do it with PHP or if
I can actually do it in a SQL statement but heres the scenario. I have 5
tables that I'm retrieving data from. The main table houses an "ownerID"
which is a number. Then number and associated owner are in a table called
owners. When I pull the results from the tables I of course get the number
of the owner. I would like to fill that in with the name of the owner upon
display. Can I modify my sql statement to take care of the association or do
I do it in PHP. Here is my current sql statement. Any help would be greatly
appreciated. Thank you

-------start sql-------

SELECT inventory.productID, inventory.price, inventory.ownerID,
minerals.speciesID, minerals.`size`
FROM inventory, minerals
WHERE minerals.productID = inventory.productID
AND inventory.productType = 'm'

-------end sql-------

Jason