Hi, everyone
I'm beginner in access and I need your help to understand how to creat a query that selects data from two tables in order to
produce a report listing the departments employees and their corresponding salaries and a reprt ensuring it prints each
department's name once only and that the departments and their employees are listed in alphabetical order:
table 1( department ID - department name - telephone number)
table 2( employee ID - surname - fornames - DOB - date employed - salary - Department ID)
Trusted
) and show them so that we understand how it goes more clearly.
