insert into enduserdevicemap (fkenduser,fkdevice,defaultprofile,tkuserassociation)
select enduser.pkid,device.pkid from enduser,device
where enduser.userid = 1001, device.name like '%6%'
values (enduser.pkid,device.pkid,'f','1')

INSERT INTO enduserdevicemap (fkenduser,fkdevice,defaultprofile,tkuserassociation)
SELECT e.fkenduser,e.fkdevice,d.defaultprofile,d.tkuserassociation
FROM enduser e,device d
WHERE enduser.userid = 1001 AND device.name like '%6%'