Oracle-L: Join Query Question

From: Gary Chambers <gc22_at_lucent.com>
Date: Thu, 14 Nov 2002 10:30:04 -0800
Message-ID: <F001.005038DE.20021114103004@fatcity.com>

All...

I'm not even sure how to ask this question, but given three tables:

pocs

poc_id     number primary key
sn         varchar2(32)

poc_hrid varchar2(16)
poctype_id number references poctypes(poctype_id)

poctypes

poctype_id number primary key
tier number(2,0)
description varchar2(64)
pocgroup_id number references pocgroups(pocgroup_id)

pocgroups

pocgroup_id number primary key
description varchar2(16)

I'm attempting to construct a single query that will provide the poc_hrid *AND* the pocgroup description to which that poc belongs. This is part of a web-based application which allows for many points-of-contact (e.g. SysAdmin, Apps, Network, etc.), but allows only members of a particular group to modify certain sections of the record. Any help will be greatly appreciated!

Gary Chambers

//--------------------------------------

// Lucent Technologies CIO/Servers/Unix
// Senior Unix System Administrator
// 4 Robbins Road, Westford, MA 01886
// 978-399-0481 / 888-480-6924 (Pager)
// Nothing fancy and nothing Microsoft

//--------------------------------------

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gary Chambers
  INET: gc22_at_lucent.com

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).

Received on Thu Nov 14 2002 - 12:30:04 CST