Question: Write statements using pgAdmin for PostgreSQL to: List all people in the database. The resulting table should have all columns of the Customer and Employee
Write statements using pgAdmin for PostgreSQL to:
List all people in the database. The resulting table should have all columns of the
Customer and Employee tables. Match the Customer and Employee tables on first and
last names. If a customer does not match any employees, the columns pertaining to the
Employee table will be null. Similarly, for an employee who does not match any
customers, the columns pertaining to the Customer table will be null.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
