MySQL question about INSERT INTO .... SELECT
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
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.