title: INSERT into a table using data from 2 other tables
body: <p>Okay so I have 3 tables; enduserdevicemap,enduser, and device.</p>
  
  <p>I'm inserting into enduserdevicemap but I need information from both the enduser table and the device table.</p>
  
  <pre><code>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')
  </code></pre>
  
  <p>I need to get device.pkid and enduser.pkid however I keep getting syntax error. I know this is wrong in so many ways...</p>