title: SQL command to insert two primary keys into third table
body: <p>I have two tables, Job(JID, agency) and Agency(AgID, Agency). And I want to create a third table Job_Agency(JID, Agid). How do I insert data into job_agency?</p>
  
  <p>Here is my info.</p>
  
  <p>so the job table is the original table, it contains job id, agency, salary, desc etc, but it is not normalized. So i created job_agency and agency tables. job_agency have jid and agid, for one agid, there are many jid assigns to it. I have done with agency table. for the job_agency table, i want each jid match to the right agld.</p>