MySQL Query Question

[Dcalladi]

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 customer name of those who are on customer sites today. For those who are not, show 'N/A' for the name and address.

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

[Tolls]

Your query and table definitions don't match.
EmployeeAssignment does not have an empId.

Anyway, assuming that's just a typo, you want to use outer joins.
Inner join the EA and CS tables together, then OUTER JOIN the employee table.
You'll then need to dig into the MySQL docs to find how you can do DECODE or CASE statements to turn the NULLs into 'N/A'.