Assuming your table is called 'names'

insert into names (name, location, category)

select 'alex', n1.category, n1.location from

names n1 where n1.name = 'james'