Creating a Mysql view to SELECT coloumns from different tables
- by user330429
I need help in constructing a VIEW on 4 tables. The view should contain coloumns:
ER.ID, ER.EMPID, ER.CUSTID, ER.STATUS, ER.DATEREPORTED, ER.REPORT, EB.NAME, CR.CUSTNAME, CR.LOCID, CL.LOCNAME, DI.DEPTNAME
ALIASES EMP_REPORT ER , EMP_BIO EB, CUST_RECORD CR, CUST_LOC CL, DEPT_ID DI
THE DATA MODELS ARE:
describe EMP_REPORT;…