title: R Sqldf: Conditional insert a binary value
body: <p>
  I'm using the sqldf package in R. I have 2 data sets,<br>
  <li> A complete list of students
  <li> A list of students who submitted an assignment. (there are missing students)</p>
  
  <p>Full list:</p>
  
  <pre><code>Student1
  Student2
  Student3
  Student4
  Student5
  </code></pre>
  
  <p>Submitted list:</p>
  
  <pre><code>Student1
  Student2
  Student5
  </code></pre>
  
  <p>I want to add a column in the full list and enter 1 or 0 depending if the student has submitted the assignment. So the final full list will look like</p>
  
  <pre><code>Student1   1
  Student2   1
  Student3   0
  Student4   0
  Student5   1
  </code></pre>
  
  <p>What would be the R code and the sql (sqlite?) code to do this? (Both for clarification's sake)</p>