Details
-
Sub-task
-
Status: Open
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
Description
Our current view implementation only supports views over a single table. We should enhance this to support creating a view over multiple tables. For example: CREATE VIEW v AS SELECT * FROM DEPT d, EMPL e WHERE d.dept_id = e.dept_id