I already have a table (EMP_DETAILS), which is containing EMP_ID (Primary Key), FIRST_NAME, LAST_NAME, AGE, ADDRESS, SALARY, DEPT_ID (Foreign Key). I want to create a view of this table.
I already created a view for the table, but when I created that table I missed one column (FIRST_NAME).
I want to add that column in this existing view with out drop this. I already try to replace this but it had shown some nothing.
Can anybody please help me out from this.
I have another question:
How I join the above table view with the another table view
(DEP_DETAILS){DEPT_ID (Primary Key), DEPT_NAME}
Can you please help me to giving the actual syntax.