I am having problems with the QBE G query. It does not display all of the employees for each project, instead it only displays one employee for every project.

QBE Queries: Using Microsoft Access QBE, create and run new queries to answer the questions that follow. Save each query using the query name format QBEQuery-#, where the # sign is replaced by the letter of the question. F. Who are the employees assigned to each project? Show ProjectID, ProjectName, Department (from the PROJECT table), EmployeeNumber, LastName, FirstName, and Phone. Create, run, and save this QBE query as QBEQuery-F Hint: QBE queries for questions G and H require more effort to produce the same results as the SQL queries. Who are the employees assigned to each project? Show ProjectID, ProjectName, Department (from the PROJECT table), Department Phone, EmployeeNumber, LastName, FirstName, and Employee Phone. Sort by ProjectlD, in ascending order. Create, run, and save this QBE query as QBEQuery-G (continued on next page) G. Query Tools 2016 file format) Access Home Create xtal Data Database Tools Help -Insert Rows utu Insert Columns Property Sheet Pass-Through : Show Data Definition Table Builder- )