Well, the code inserts a new row for all matches in the SELECT statement.
So the red part is like that since it is a SELECT statement, not a VALUES. SELECT usually provides the table and possibly a WHERE statement, no?
Its kind of like doing what tommy suggested, but doing it automatically, its normal SQL.
Not really much I can say to tell you why, when it is like that since that is how it works .. : |
Unsure what you are asking exactly
Google sql insert into select?