RE: Join Query Question

From: Carle, William T (Bill), ALCAS <wcarle_at_att.com>
Date: Thu, 14 Nov 2002 10:56:09 -0800
Message-ID: <F001.005039A2.20021114105609@fatcity.com>

select a.poc_hrid,c.description from pocs a, poctypes b, pocgroups c where a.poctype_id = b.poctype_id
and b.pocgroup_id = c.pocgroup_id;

Bill Carle
AT&T
Database Administrator
816-995-3922
wcarle_at_att.com

 -----Original Message-----

Sent:	Thursday, November 14, 2002 12:30 PM
To:	Multiple recipients of list ORACLE-L
Subject:	Join Query Question

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Carle, William T (Bill), ALCAS
  INET: wcarle_at_att.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:56:09 CST