• I think that this question is ambiguous and should be withdrawn.

    There is NO query returning zero rows in the question.

    There is one insert statement yielding five rows affected.

    You might have missed the extra UNION ALL but others will just see it as it is and think it is a question about attempting to reference rows yet to be inserted.

    Regards, Murray.