how to pull up specific records in MySQL : I have some SQL i would like to pull up some records with a certain criteria please help, thank you :)

**SQL Statement:**

`SELECT
          b.*,
          e.Lastname,
          e.Firstname,
          e.ID_SC,
          e.Program,
          r.BReasonDetails
          FROM tblbadgetemporaryborrower b
          INNER JOIN (SELECT e.*, p.Program FROM tblemployee e INNER JOIN tblemployeeprogram p ON p.ID_P = e.ID_P) e ON e.EmployeeID = b.EmployeeID
          INNER JOIN tblbadgetemporaryborrowerreason r ON r.ID_BR = b.ID_BR
          HAVING e.ID_SC = {$_GET['ID_SC']} ORDER BY b.EmployeeID ASC`

**Here's what i have:**

**Q:** How can i pull up the employee data with `Lost` reason only

[![enter image description here][1]][1]


  [1]: http://i.stack.imgur.com/vN6x0.png