MySQL about employee and staff and nulls using joins
===

i have three tables 

Employee 
empId int pk 
empname varchar 

customersite 
empid int pk fk 
custid int pk fk 
startdate date pk 
enddate date 

employeeassignment 
custid int pk 
sitename varchar 

my question is 

How to show the name of all our employees with the site name of those who are on customer sites today. For those who are not on customer site today, show thier name and 'N/A' for the site name. 

i have so far


    SELECT
    e.EmpName,
    cs.SiteName
    FROM
    EmployeeAssignment ea
    INNER JOIN
    Employee e
    ON
    e.EmpId = ea.EmpId
    INNER JOIN
    CustomerSite cs
    ON
    cs.CustId = ea.CustId


which give me all employee at work today, with their name and the site. 

any help you be very appreciated thanks