How Do I Insert Into A Table From Another Table With Some Additional Data?

See more:

SQL-Server-2005

SQL

Dear everyone,
I have the issue that i don't know how to insert into a table from another table with some additional data like this:
Table Student
ID| Name
01| Jimmy
02| Tom
....( a lot data).....

Table Result
ID|Name|Course|Result
01|01 |Math | A+
02|02 |Lit | C
...( a lot data).....

Table Courses
ID |CourseName |Price
Math|Mathematics | 15$
Lit |Literature | 20$
......(a lot data).......

I want to add into Result like this,and i knew the 'Kate' student must be added 10 courses more:

insert into result(ID, Name,Course) select * from Course with ID=10000 and name='Kate'

But i know there is no way like that in SQl.

Is there anyway so that we can insert into table from another table with some variables, without using function and store?

I am using sql 2005.

Really have no idea.
Please give me ur hands or just a little of hints!
Thank in advance.
Sincerely.
Toki.