Because MySQL doesn't allow views or subselects I'm trying to get around it by creating an intermediate table and fill it with the records from the first select. The select looks something like this

insert into intermediate (unique_id, registration_id)
select 111, ez.registration_id
from table

If I just do the select it retreives 2 rows but if I run it like this, it only creates one row. Does anyone know what this problem is, I've been looking around the net for a couple of hours and I can't find anything, so any help would be greatly appreciated.

Mike