Try something like this:
insert into onTeam(date, player, teamName)
select 'newDate','Matt Holliday', teamName
from onTeam where player = 'Matt Holliday'All entries tagged insert.
You can subscribe to an RSS feed of this list.
Roy Tang
Programmer, engineer, scientist, critic, gamer, dreamer, and kid-at-heart.