var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: MySQL Query Question
i have three tables
empId int pk
empid int pk fk
custid int pk fk
startdate date pk
custid int pk
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
e.EmpId = ea.EmpId
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
that's not going to work, because your EmployeeAssignment doesn't have an Empid column
Originally Posted by
by the way, are you using mysql or microsoft sql server? because you posted in the sql server forum
Do you by any chance changed the names of tables customersite and employeeassignment?
Because the SQL statement you posted does not match the structure of tables.
And I have not found the customer_name or customer_address columns in any of the tables.