I am trying to create a search results page that has a table on it:

Manufacturer Name, Make Name, Model, Desc., Price.

In order to retrieve the above information I use the following SQL (after a search is done from a dropdown box selection):

Code:
SELECT *
FROM prod_items  INNER JOIN prod_make ON prod_items.make_ID= prod_make.make_ID INNER JOIN prod_model ON prod_items.model_ID= prod_model.model_ID  INNER JOIN prod_man ON prod_items.man_ID= prod_man.man_ID
I have a table for man, one for make, one for model, a final for items being sold. (I inner join them to display certain info)

I would like to change my table to be this:

Manufacturer Name, Make Name, Available Models, Desc., Price.

So when the search page results comes up, all available models will be present in that cell. *My initial plan is to have the same price for all models from that manufacturer*

How can I change my SQL to list all available models from the items table?!