title: Creating a relationship between two tables and creating a foreign key
body: <p>Example, we have two tables as</p>
  
  <pre><code>creators (
  creatorid int not null,
  title varchar(100) not null, 
  primary key(creatorid)
  );
  
  authors (
  creatorid int not null,
  titleid int not null,
  primary key (creatorid, titleid)
  );
  </code></pre>
  
  <p>Ok, I ask how to make relationship? I think that creatorid must relate with creatorid in second table, but I don't know how make it. </p>