title: Only a single result allowed for a SELECT that is part of an expression
body: <p>I have the following SQL statement. It's throws the following error: "Only a single result allowed for a SELECT that is part of an expression". The goal of my sql statement is to get the name of the employee who made the 'cheapest' bribe. </p>
  
  <p>The part between the brackets return the employee_id and the money it costs a day (of the relative cheapest bribe). These are two results while I only want the employee_id. So I just want to use the MIN part to get the right employee_id. How can I do this?</p>
  
  <pre><code>SELECT Voornaam, Achternaam
  FROM Medewerker m JOIN
       (
        SELECT Medewerker_id
        FROM Steekpenning
        ORDER BY -1*Bedrag/(julianday(Begindatum) - julianday(Einddatum))
        limit 1
       ) s
       on m.Medewerker_id = s.Medewerker_id;
  </code></pre>
  
  <p>EDITED the answer. How can I expand this query to only show the bribes started this month? I think I need to use something like this? (julianday(Begindatum) - julianday('now')) > 31 but where?</p>
  
  <p>Regards.
  Cas</p>