Mysql query join ids

Databases
1

Hello forums

I have this table

id year make model product_id
1 2001 Ford F-150 100
2 2001 Ford F-150 101
3 2001 Ford F-150 102

I want to copy this to a view table with end result like this

id year make model product_id
1 2001 Ford F-150 100,101,102

maybe something like:

CREATE OR REPLACE VIEW view_table AS
SELECT * FROM table

Is this even possible?

Thanks

2 
SELECT MIN(id) AS id
     , `year`
     , make 
     , model 
     , GROUP_CONCAT(product_id) AS product_id
  FROM daTable
GROUP
    BY `year`
     , make 
     , model
3

Wow GROUP_CONCAT
Thanks r937 I’ll experiment on that…