Use the Ex database Employee ID from the Employees table Employee First Name and Employee Contact Last Name from the Emp

[answerhappygod]

Use The Ex Database Employee Id From The Employees Table Employee First Name And Employee Contact Last Name From The Emp 1 (33.59 KiB) Viewed 26 times

output that i need:

Use The Ex Database Employee Id From The Employees Table Employee First Name And Employee Contact Last Name From The Emp 2 (44.16 KiB) Viewed 26 times

Use the Ex database Employee ID from the Employees table Employee First Name and Employee Contact Last Name from the Employees table but I need them concatenated together with a space between the names Count the number of characters in the employee's last name Department number from Employees table Department name from the Department table Project number from the Project table Every employee gets a base salary of 45000.00 to 2 decimals Count the number of days between today's date and your birth date The FROM is the Employees table do JOINS on the others The WHERE is the project number is equal to P1012 and the department number is equal to 2 Sort by employee last name in ascending order Column heading names MUST match mine, see printout below
Tools Scripting Help a Test#2 x Limit to 1000 rows Result Grid Filter Rows: Export: Wrap Cell Content: LA Employeeld EmployeeName LastNameChar Dept Deptame Project Base Salary DaysFrom YourBirth Robert Aaronsen 8 Payroll P1012 45000.00 21823 3 Ralph Simonian 2 Payroll P1012 45000.00 21823 Cindy Smith Payroll P101245000.00 21823 2 8 1 5 2 Result 1 x Output Action Output Time Action 1 13:34:38 SELECT emp. employee_id AS EmployeeID. CONCAT(emp first_name,"emp last_name) AS Employ... 3 row(s) 2 13:37:46 SELECT emp employee_id AS EmployeeID. CONCAT (emp first_name.". emplast_name) AS Employ... 3 row(s) Message