PERSON_CUSTOMER_VIEW |
||
| Column Name | Data Type | Nulls |
|---|---|---|
| person_key | decimal (15,0) | |
| person_code | varchar (5) | YES |
| username | varchar (16) | |
| first_name | varchar (50) | YES |
| last_name | varchar (50) | YES |
| emp_id | varchar (25) | YES |
| varchar (50) | YES | |
| customer_code | varchar (25) | YES |
Tables Used |
| CUSTOMER |
| PERSON |
SQL*Server Create Statement: |
CREATE VIEW person_customer_view AS
SELECT person.person_key, person.person_code, person.username,
person.first_name, person.last_name, person.emp_id,
person.email, customer.customer_code
FROM person, customer
WHERE person.customer_key *= customer.customer_key
|