-- ------------------------------------------------------------- 
-- Automatisch von ER2SQL 3.38 erzeugter File. 
-- Funktion: SQL-Code fuer Oracle 7/8 
-- Erzeugungsdatum : Sat Jan 31 23:34:54 2004 
-- 
-- ------------------------------------------------------------- 
-- Copyright (C) 1995-2004 by Joerg Hoppe, Goettingen, Germany.
-- email: j_hoppe@t-online.de 
-- ------------------------------------------------------------- 



  /* Alias 'LOCATION' = DB-Table: keine Alias-View noetig. */
  /* Alias 'DEPARTMENT' = DB-Table: keine Alias-View noetig. */
  /* Alias 'ADDRESS' = DB-Table: keine Alias-View noetig. */

CREATE OR REPLACE VIEW vt_DEPTS AS SELECT
    LOCATION.REGIONAL_GROUP	REGIONAL_GROUP,
    DEPARTMENT.NAME	DEPARTMENT_NAME,
    ADDRESS.STREET	street,
    ADDRESS.CITY	CITY,
    ADDRESS.STATE	STATE,
    ADDRESS.ZIP_CODE	ZIP_CODE
  FROM LOCATION,
    DEPARTMENT,
    ADDRESS
  WHERE LOCATION.LOCATION_ID = DEPARTMENT.LOCATION_ID
    AND ADDRESS.ADDRESS_ID = DEPARTMENT.ADDRESS_ID ;