I need to add multiple records based on data from another table where the event is the same. I've found on this forum

insert into table2(id,name) select "001",first_name from table1 where table1.id="001" as possible solution for my question.

So I thought this should be the following syntax:

insert into reservations(event,seat) select "99",id from seats where seats.id>0 

to add all seats to event 99. However when I run this query mysql gives the message 'MySQL returned an empty resultset (0 rows). (query 0.0028 sec)' and no records were added. I translated the message so could be sligthly different.

When I only use the "select "99",id from seats where seats.id>0" query, it returns me 1080 rows.