SQL: Pipe SELECT statement into an INSERT

gistfile1.sql

insert into register
(

fName,lName,sex,bDay,grade,activity,fee,cityRes,tFee,rel,rel_fName,rel_lName,rel_add1,rel_ad2,rel_city,rel_state,rel_zip,rel_phone,rel_altPhone,rel_email

)
select

	'Chris' as fName,  /* Hardcodes Chris as First Name for new records created */
	'Brown' as lName, /* Hardcodes Brown as Last Name for new records created */
	sex,                        /* insert actual value from sex column  */
	bDay,
grade,
activity,
fee,
cityRes,
tFee,
rel,
rel_fName,
rel_lName,
rel_add1,
rel_add2,
rel_city,
rel_state,
rel_zip,
rel_phone,
rel_altPhone,
rel_email
from register
where id > 0 and id < 50