RE: view to join tables

Did a union of the rows across the tables and the view works fine.  

rhr  

-----Original Message-----
Sent: Monday, March 03, 2003 11:04 AM
To: Multiple recipients of list ORACLE-L      

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        

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Richmond, Robert
  INET: Robert.Richmond_at_ci.raleigh.nc.us

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).