From the employees table first name. last_name From the orders table onder date order_num
employees, orders
relate the tables on the employee_id field
- use a LEFT JOIN statement to join the
tables
• Restrict the returned records to only show
the records where the employee has not
made any orders

Need to put in SQL SYNTAX

select

employees.firstname,

employees.lastname,

orders.orderdate,

orders.ordernum

from

employees

left join orders on orders.employees_id = employees.employee_id

where

orders.ordernum is null

group by 1,2,3,4

Explanation:

the left join gives you all the data in the employees table with matching records in the orders table

each order has has an employee ID because an employee would have made several orders

join the two tables with the ID numbers which are called keys

sql with search record where ordernum is empty in the two matching tables and return employee with no order record

I hope you understand this and it helps

a macro is a tool that allows you to automate tasks and add functionality to your forms, reports, and controls. for example, if you add a command button to a form, you associate the button's onclick event to a macro, and the macro contains the commands that you want the button to perform each time it is clicked.