Using the l_employees, l_departments, l_lunches, l_foods,
l_lunch_items, and l_suppliers tables
show the employee name, lunch_date, description of food ordered,
quantity, and supplier name
of all the items ordered by employees. Make sure you show all
employees in your results.
[l_lunches database]
This is what I have so far:
select first_name + ' ' + last_name as [Full Name]
department_name, lunch_date, quantity,
description, supplier_name
from l_employees e left join l_departments d on e.dept_code =
d.dept_code
Result should look like this:
- Using Ap And L Lunches Database Using The L Employees L Departments L Lunches L Foods L Lunch Items And L Suppliers 1 (155.71 KiB) Viewed 31 times