RE: view to join tables

[Richmond, Robert]

Did a union of the rows across the tables and the view works fine.   rhr   -----Original Message----- From: Richmond, Robert Sent: Monday, March 03, 2003 11:04 AM To: Multiple recipients of list ORACLE-L Subject: view to join tables       I need to create a view to join 13 tables.  The objective is to have one view that allows basic queries on permit types (building, electrical, plumbing, signs, mechanical....).  Each type of permit and it associated information is stored in separate tables, and a column in each table (permit_type_code) indicates the type of permit.    The common columns in each table are:   Group_num Permit_type_code Permit_num Perm_contractor_name Perm_work_type_code_descr Perm_authorized_work Perm_c_status   The tables are named (partial listing):   Perm_bldg Perm_elec Perm_mech Perm_signs .....     Any queries that are currently used are done against the table containing the appropriate permit_type_code.  There are separate permit_num's for each permit_type_code. There are 1 or more permit_num's associated with a given group_num.   I'm not sure if I'm making any sense, but would appreciate any insight from the group.     Regards,   Robert Richmond