Answer Happy

Using AP and l_lunches database
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:
1 Results ET Messages Full Name department_name lunch_date SUSAN BROWN EXECUTIVE 2011-11-16 SUSAN BROWN EXECUTIVE 2011-11-16 SUSAN BROWN EXECUTIVE 2011-11-16 SUSAN BROWN EXECUTIVE 2011-11-25 quantity 1 2 description FRESH SALAD SANDWICH COFFEE FRESH SALAD supplier_name A SOUP PLACE A SOUP PLACE JUST BEVERAGES 2 3 2 4 1 A SOUP PLACE -