Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Some beginner's help please?

Some beginner's help please?

From: Randy <dmnelson50_at_hotmail.com>
Date: Fri, 18 Oct 2002 16:53:17 GMT
Message-ID: <10Xr9.76943$om2.1384597@twister.rdc-kc.rr.com>


I have this query I've been trying to write all week and had no success. Here's the problem.

In table "A" I list a TRBLTKT number, CREATEDBY number and CLOSEDBY number. The Createdby and Closedby numbers join over to another table called PERSONAL, that has IDNUM, LASTNAME and FIRSTNAME as fields. My problem is, how do I write a select that resolves the Createdby and closedby numbers seperately (if they were different people). For one, I'd do:
select a.trbltkt, personal.lastname from a, personal where a.createdby = personal.idnum;

how do I write it to match both fields.. I'm stumped.. help please...

                             Randy
Received on Fri Oct 18 2002 - 11:53:17 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US